USE enwiki_p;
SELECT pl_from, pl_from_namespace, COUNT(pl_title)
FROM... |
4 years ago |
USE enwiki_p;
SELECT * FROM page AS conid;
SHOW EXPLAIN FOR conid; |
4 years ago |
USE enwiki_p;
SHOW EXPLAIN FOR page; |
4 years ago |
USE enwiki_p;
SHOW EXPLAIN SELECT * FROM page; |
4 years ago |
USE enwiki_p;
EXPLAIN SELECT * FROM page; |
4 years ago |
USE enwiki_p;
EXPLAIN SELECT COUNT(*) FROM page; |
4 years ago |
USE enwiki_p;
DESCRIBE SELECT COUNT(*) FROM page; |
4 years ago |
USE enwiki_p;
DESCRIBE page; |
4 years ago |
USE enwiki_p;
DESCRIBE TABLES; |
4 years ago |
USE enwiki_p;
DESCRIBE TABLE; |
4 years ago |
USE enwiki_p;
SHOW TABLE; |
4 years ago |
select * from information_schema.TABLES where table_name = 'page'\G |
4 years ago |
USE enwiki_p;
select * from information_schema.TABLES where table_name = 'page'\G |
4 years ago |
USE enwiki_p;
SHOW TABLE page STATUS; |
4 years ago |
USE enwiki_p;
SHOW TABLE STATUS; |
4 years ago |
USE enwiki_p;
SHOW table STATUS; |
4 years ago |
USE enwiki_p;
SHOW page STATUS; |
4 years ago |
use enwiki_p;
describe page; |
4 years ago |
use enwiki_p;
describe page; |
4 years ago |
use enwiki_p;
SHOW tables; |
4 years ago |
use enwiki_p;
SELECT Count(*) FROM page; |
4 years ago |
use enwiki_p;
SELECT Count(*) FROM pagelinks; |
4 years ago |
use enwiki;
SELECT Count(*) FROM pagelinks; |
4 years ago |
SELECT Count(*) FROM pagelinks; |
4 years ago |