|
select concat("https://en.wikipedia.org/user/", rev_actor,"&page=",... |
2 years ago |
|
select concat("https://en.wikipedia.org/user/",rev_actor,"&page=",... |
2 years ago |
| select rev_page, rev_actor, rev_sha1 from revision limit 10; |
2 years ago |
| select rev_page, rev_actor, rev_sha1 from revision where rev_sha1 regexp... |
2 years ago |
| select rev_page, rev_actor, rev_sha1 from revision where rev_sha1 regexp... |
2 years ago |
| select rev_page, rev_actor, rev_sha1 from revision where rev_sha1 regexp... |
2 years ago |
| select rev_page, rev_actor, rev_sha1 from revision where rev_sha1 regexp... |
2 years ago |
| select rev_page, rev_actor, rev_sha1 from revision where regexp 'ff' limit 10; |
2 years ago |
| select rev_page, rev_actor, rev_sha1 from revision where regexp "x" limit 10; |
2 years ago |
| select rev_page, rev_actor, rev_sha1 from revision where rev_sha1 like... |
2 years ago |
| select rev_page, rev_actor from revision where rev_sha1 like "%uf%" limit 10; |
2 years ago |
| select rev_page, rev_actor from revision where rev_sha1 like "uf%" limit 10; |
2 years ago |
| select * from revision where rev_timestamp between "20020126143230" and... |
2 years ago |
| select * from revision where rev_sha1 like "uf%" limit 10; |
2 years ago |
| select * from revision where rev_timestamp between "20020126143230" and... |
2 years ago |
| select * from revision where rev_timestamp between 20020126143230 and... |
2 years ago |
| select * from revision where rev_timestamp between 20020126143230 and... |
2 years ago |
| select * from revision where rev_timestamp between "20020126143230" and... |
2 years ago |
| select * from revision where rev_timestamp 20020126143230 and 20020126144331... |
2 years ago |
| select * from revision limit 10; |
2 years ago |
| select rev_page, rev_timestamp from revision limit 10; |
2 years ago |
| select rev_page, rev_timestamp from revision where rev_actor = (select... |
2 years ago |
| select rev_actor, rev_page, rev_timestamp from revision limit 10; |
2 years ago |
| select rev_actor, rev_page, rev_timestamp from revision order by rev_actor limit 10; |
2 years ago |
| select rev_actor, rev_page, rev_timestamp from revision order by rev_actor... |
2 years ago |
| select rev_actor, rev_page, rev_timestamp from revision limit 10 order by rev_actor; |
2 years ago |
| select rev_actor, rev_page, rev_timestamp from revision limit 10; |
2 years ago |
| select rev_actor, rev_page, rev_timestamp from revision order by rev_actor limit 10; |
2 years ago |
| select rev_actor, rev_page, rev_timestamp from revision limit 10; |
2 years ago |
| describe revision; |
2 years ago |
| select rev_actor, rev_page, rev_timeline from revision limit 10; |
2 years ago |
| select rev_actor, rev_page, rev_timeline from revison limit 10; |
2 years ago |
| show rev_actor, rev_page from revison limit 10; |
2 years ago |
| show rev_actor, rev_page, rev_timeline from revison limit 10; |
2 years ago |
| show rev_actor, rev_page, rev_actor from revison limit 10; |
2 years ago |
| describe revision; |
2 years ago |
| show tables; |
2 years ago |
