SELECT COUNT(*) AS linkscount, pl_title FROM pagelinks WHERE pl_namespace =... |
7 years ago |
SELECT rev_page, page_title, rev_timestamp, rev_user, user_name
FROM... |
7 years ago |
SELECT * FROM user limit 10;
|
7 years ago |
SELECT rev_page, page_title, rev_timestamp FROM revision JOIN page ON... |
7 years ago |
SELECT rev_page FROM revision ORDER by rev_timestamp DESC limit 10; |
7 years ago |
SELECT * FROM revision ORDER by rev_timestamp LIMIT 10; |
7 years ago |
SELECT * FROM revision LIMIT 10
|
7 years ago |
SELECT * FROM page LIMIT 10
|
7 years ago |
DESCRIBE page
|
7 years ago |
DESCRIBE page WHERE page_title = "Oxford"
|
7 years ago |
DESCRIBE page
|
7 years ago |
DESCRIBE "Oxford"
|
7 years ago |
DESCRIBE "Oxford"
|
7 years ago |
DESCRIBE "Oxford"
|
7 years ago |
DESCRIBE "Oxford"
|
7 years ago |
DESCRIBE "Oxford"
|
7 years ago |
DESCRIBE page_title = "Oxford"
|
7 years ago |
SHOW TABLES
|
7 years ago |
USE simplewiki_p SHOW TABLES
|
7 years ago |
SHOW DATABASES
|
7 years ago |
SELECT pl_from, page_title
FROM pagelinks JOIN page ON page_id = pl_from... |
7 years ago |