DESCRIBE page |
6 years ago |
SELECT COUNT(*)
FROM pagelinks
WHERE `pl_namespace` = 0
AND `pl_from_namespace` = 0 |
6 years ago |
SELECT `pl_from`, `pl_title`
FROM pagelinks
WHERE `pl_namespace` = 0
AND... |
6 years ago |
SELECT COUNT(*)
FROM page
WHERE `page_namespace` = 0
AND `page_is_redirect` = 0 |
6 years ago |
SELECT COUNT(*) FROM page |
6 years ago |
SELECT * FROM SHOW TABLE STATUS WHERE `Name` = 'pagelinks' |
6 years ago |
SELECT * FROM (SHOW TABLE STATUS) AS tbl1 WHERE `Name` = 'pagelinks' |
6 years ago |
SHOW TABLE STATUS |
6 years ago |
SELECT COUNT(*) FROM pagelinks |
6 years ago |