USE simplewiki_p;
SELECT pl_from, page_title FROM pagelinks JOIN page ON... |
5 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, page_title FROM... |
5 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
5 years ago |
USE simplewiki_p;
SHOW TABLES |
5 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name... |
5 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) FROM revision GROUP by rev_user ORDER... |
5 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) FROM revision GROUP by rev_user ORDER... |
5 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts FROM revision GROUP by... |
5 years ago |
USE simplewiki_p;
SELECT rev_page, page_title, rev_timestamp, rev_user,... |
5 years ago |
USE simplewiki_p;
SHOW TABLES |
5 years ago |
USE simplewiki_p;
SELECT rev_page, page_title, page_id, rev_timestamp FROM... |
5 years ago |
USE simplewiki_p;
DESCRIBE page; |
5 years ago |
USE simplewiki_p;
DESCRIBE PAGE |
5 years ago |
USE simplewiki_p;
SHOW TABLES |
5 years ago |
USE simplewiki_p; |
5 years ago |
USE simplewiki_p;
SELECT rev_page, page_title, rev_timestamp FROM revision... |
5 years ago |
USE simplewiki_p;
SELECT * FROM page LIMIT 10 |
5 years ago |
USE simplewiki_p;
SHOW TABLES |
5 years ago |
USE simplewiki_p;
SELECT rev_page, page_title, rev_timestamp FROM revision... |
5 years ago |
SELECT rev_page, page_title, rev_timestamp FROM revision JOIN page ON... |
5 years ago |
USE simplewiki_p;
#DESCRIBE page;
SELECT * FROM page LIMIT 10
Wikimedia... |
5 years ago |
USE simplewiki_p;
#DESCRIBE page;
SELECT * FROM page LIMIT... |
5 years ago |
USE simplewiki_p;
#DESCRIBE page;
SELECT * FROM page LIMIT 10 |
5 years ago |
USE simplewiki_p;
DESCRIBE page;
ELECT * FROM page LIMIT 10 |
5 years ago |
USE simplewiki_p;
DESCRIBE page; |
5 years ago |
USE simplewiki_p;
SHOW TABLES;
|
5 years ago |
USE simplewiki_p; |
5 years ago |
SHOW DATABASES;
a. enwiki_p
b. dewiki_p
c. simplewiki_p
|
5 years ago |
1. SHOW DATABASES;
a. enwiki_p
b. dewiki_p
c. simplewiki_p
|
5 years ago |