| USE svwiki_p;
SELECT COUNT(rev_id) FROM revision GROUP by rev_user LIMIT 10;
|
7 years ago |
| USE svwiki_p;
SELECT COUNT(rev_id) FROM revision GROUP by rev_user LIMIT 10;
|
7 years ago |
| USE svwiki_p;
SELECT COUNT(rev_id) FROM revision WHERE rev_user = "66249"; |
7 years ago |
| USE svwiki_p;
SELECT COUNT(rev_id) FROM revision WHERE rev_user = "66249"; |
7 years ago |
| USE svwiki_p;
SELECT COUNT(rev_id) FROM revision WHERE rev_user = "66249"; |
7 years ago |
| USE svwiki_p;
SELECT COUNT(rev_id) FROM revision WHERE rev_user = "66249"; |
7 years ago |
| USE svwiki_p;
SELECT COUNT(rev_id) FROM revision WHERE rev_user = "66249"; |
7 years ago |
| USE svwiki_p;
SELECT COUNT(rev_id) FROM revision WHERE rev_user = "Ljusmumrik"; |
7 years ago |
| USE svwiki_p;
SELECT COUNT(rev_id) FROM revision WHERE rev_user = "Ljusmumrik"; |
7 years ago |
| USE svwiki_p;
SELECT COUNT(rev_id) FROM revision WHERE rev_user = "66249"; |
7 years ago |
| USE svwiki_p;
SELECT rev_page, page_title, rev_timestamp, rev_user,... |
7 years ago |
| USE svwiki_p;
SELECT * FROM user limit 10;
|
7 years ago |
| USE svwiki_p;
SELECT rev_page, page_title, rev_timestamp FROM revision JOIN... |
7 years ago |
| USE svwiki_p;
SELECT rev_page FROM revision ORDER by rev_timestamp ASC limit 10; |
7 years ago |
| USE svwiki_p;
SELECT rev_page FROM revision ORDER by rev_timestamp DESC limit 10; |
7 years ago |
| USE svwiki_p;
SELECT * FROM revision ORDER by rev_timestamp LIMIT 50; |
7 years ago |
| USE svwiki_p;
SELECT * FROM revision ORDER by rev_timestamp LIMIT 10; |
7 years ago |
| USE svwiki_p;
SELECT * FROM revision LIMIT 10; |
7 years ago |
| USE svwiki_p;
#SHOW TABLES;
#DESCRIBE page;
#SELECT * FROM page LIMIT... |
7 years ago |
| USE svwiki_p;
#SHOW TABLES;
#DESCRIBE page;
SELECT * FROM page LIMIT 10; |
7 years ago |
| USE svwiki_p;
#SHOW TABLES;
DESCRIBE page; |
7 years ago |
| USE svwiki_p;
SHOW TABLES; |
7 years ago |
