SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
1 year ago |
SELECT rc_title, count(*) as num_edits
FROM recentchanges
WHERE... |
1 year ago |
SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
1 year ago |
SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
1 year ago |
SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
1 year ago |
SELECT *
FROM recentchanges
LIMIT 25; |
1 year ago |
SELECT rc_title, count(*) as num_edits
FROM recentchanges
WHERE... |
1 year ago |
SELECT *
FROM `page`
LIMIT 19; |
1 year ago |
SELECT *
FROM `archive`
LIMIT 19; |
1 year ago |
SELECT *
FROM `page`
LIMIT 19; |
1 year ago |
show tables |
1 year ago |
select
url
from
Pages
where
url_domain = 'wikipedia.org' |
1 year ago |
select
url
from
Pages
where
url_domain = 'wikipedia.org' |
1 year ago |
select
url
from
pages
where
url_domain = 'wikipedia.org' |
1 year ago |
SELECT *
FROM `page`
LIMIT 19; |
1 year ago |
SELECT *
FROM `page`
LIMIT 25; |
1 year ago |
SELECT *
FROM `Pages`
LIMIT 25; |
1 year ago |
SELECT *
FROM `user`
LIMIT 25; |
1 year ago |
SELECT rc_title, count(*) as num_edits
FROM recentchanges
WHERE... |
1 year ago |
SELECT * FROM `user`; |
1 year ago |
SELECT COUNT(actor_id) FROM actor |
1 year ago |
SELECT * FROM COUNT(actor) |
1 year ago |
SELECT COUNT(actor) |
1 year ago |
COUNT(actor) |
1 year ago |
COUNT(actor) |
1 year ago |
COUNT actor |
1 year ago |
DESCRIBE actor |
1 year ago |
SELECT * FROM actor |
1 year ago |
SELECT * FROM Actor Migration |
1 year ago |
SELECT * |
1 year ago |
blank query |
1 year ago |