USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts FROM revision GROUP by... |
7 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) FROM revision GROUP by rev_user LIMIT 10;
|
7 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) FROM revision WHERE rev_user = "66249"; |
7 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) FROM revision WHERE rev_user = "66249"; |
7 years ago |
USE simplewiki_p;
SELECT rev_page, page_title, rev_timestamp, rev_user,... |
7 years ago |
USE simplewiki_p;
SELECT rev_page, page_title, rev_timestamp, rev_user,... |
7 years ago |
USE simplewiki_p;
SELECT rev_page, page_title, rev_timestamp, rev_user,... |
7 years ago |
USE simplewiki_p;
SELECT rev_page, page_title, rev_timestamp, rev_user,... |
7 years ago |
USE simplewiki_p;
SELECT rev_page FROM revision ORDER by rev_timestamp DESC... |
7 years ago |
USE simplewiki_p;
SELECT rev_page FROM revision ORDER by rev_timestamp DESC... |
7 years ago |
USE simplewiki_p;
SELECT rev_page FROM revision ORDER by rev_timestamp DESC... |
7 years ago |
USE simplewiki_p;
SELECT * FROM revision ORDER by rev_timestamp LIMIT 10;
|
7 years ago |
USE simplewiki_p;
SELECT * FROM revision ORDER by rev_timestap LIMIT 10;
|
7 years ago |
USE simplewiki_p;
SELECT * FROM revision LIMIT 10;
|
7 years ago |
USE simplewiki_p;
SELECT * FROM revisison LIMIT 10;
|
7 years ago |
USE simplewiki_p;
SELECT * FROM revison LIMIT 10;
|
7 years ago |
USE simplewiki_p;
#SHOW TABLES;
#DESCRIBE page;
SELECT * FROM page;
|
7 years ago |
USE simplewiki_p;
#SHOW TABLES;
#DESCRIBE page;
SELECT * FROM page LIMIT 10;
|
7 years ago |
USE simplewiki_p;
#SHOW TABLES;
DESCRIBE page;
|
7 years ago |
USE simplewiki_p;
SHOW TABLES;
|
7 years ago |
USE simplewiki_p;
|
7 years ago |
USE enwiki_p;
|
7 years ago |
SHOW enwiki_p;
|
7 years ago |
SHOW DATABASES;
|
7 years ago |