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