| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT COUNT(DISTINCT(rev_user)) as U,
COUNT(rev_id) as E,... |
6 years ago |
| USE afwiki_p;
SELECT page_id, page_title, page_namespace,
page_len AS T,... |
6 years ago |
| USE afwiki_p;
SELECT page_id, page_title, page_namespace,
page_len AS T,... |
6 years ago |
| USE afwiki_p;
SELECT page_id, page_title, page_namespace,
page_len AS T,... |
6 years ago |
| USE afwiki_p;
SELECT page_id, page_title, page_namespace,
page_len AS T,... |
6 years ago |
| USE afwiki_p;
SELECT page_id, page_title, page_namespace,
page_len AS T,... |
6 years ago |
| USE afwiki_p;
SELECT page_id, page_title, page_namespace,
page_len AS T,... |
6 years ago |
| USE afwiki_p;
SELECT page_id, page_title, page_namespace,
page_len AS T,... |
6 years ago |
| USE afwiki_p;
SELECT page_id, page_title, page_namespace,
page_len AS T,... |
6 years ago |
| USE afwiki_p;
SELECT page_id, page_title, page_namespace,
page_len AS T,... |
6 years ago |
| USE afwiki_p;
SELECT page_id, page_title, page_namespace,
page_len AS T,... |
6 years ago |
| USE afwiki_p;
#SELECT page_id, page_title, page_namespace,
# page_len AS... |
6 years ago |
| USE afwiki_p;
#SELECT page_id, page_title, page_namespace,
# page_len AS... |
6 years ago |
| USE afwiki_p;
#SELECT page_id, page_title, page_namespace,
page_len AS... |
6 years ago |
| USE afwiki_p;
SELECT page_id, page_title, page_namespace,
page_len AS T,... |
6 years ago |
| USE afwiki_p;
SELECT page_id, page_title, page_namespace,
page_len AS T,... |
6 years ago |
| USE afwiki_p;
SELECT rev_id
FROM revision
JOIN page on page_id == rev_id |
6 years ago |
| USE afwiki_p;
SELECT rev_id
FROM revision
JOIN page on page_id == rev_id |
6 years ago |
| USE afwiki_p;
SELECT rev_id
FROM revision
JOIN page on rev_id == page_id |
6 years ago |
| USE afwiki_p;
SELECT rev_id
FROM revision
JOIN page on rev_id == page_id |
6 years ago |
| USE afwiki_p;
SELECT page_id
FROM revision
JOIN page on rev_id == page_id |
6 years ago |
| USE afwiki_p;
describe revision; |
6 years ago |
| USE afwiki_p;
describe revisions; |
6 years ago |
| USE afwiki_p;
describe page; |
6 years ago |
| USE afwiki_p;
show tables; |
6 years ago |
| USE afwiki_p;
SHOW TABLES; |
6 years ago |
| USE afwiki_p;
SELECT page
|
6 years ago |
| USE afwiki_p;
SELECT page_id
|
6 years ago |
| USE afwiki_p;
SELECT page_id
FROM revisions |
6 years ago |
| USE afwiki_p;
SHOW TABLES; |
6 years ago |
| USE itwiki_p;
SHOW TABLES; |
6 years ago |
| USE afwiki_p;
SHOW TABLES; |
6 years ago |
| SHOW afwiki_p; |
6 years ago |
| SHOW DATABASES; |
6 years ago |
| SHOW DATABASES; |
6 years ago |
| USE dewiki_p;
SELECT count(page); |
6 years ago |
| USE dewiki_p;
SELECT count(page); |
6 years ago |
| USE dewiki_p;
SELECT page; |
6 years ago |
| USE dewiki_p;
SHOW Tables |
6 years ago |
| SHOW DATABASES |
6 years ago |
| USE dewikinews_p;
SHOW TABLES
#SELECT COUNT(rev_id) AS editcounts,... |
6 years ago |
| SHOW DATABASES; |
6 years ago |
