mysql查询各种对象
1 SHOW DATABASES [LIKE wild]
2 or SHOW [OPEN] TABLES [FROM db_name] [LIKE wild]
3 or SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE wild]
4 or SHOW INDEX FROM tbl_name [FROM db_name]
5 or SHOW TABLE STATUS [FROM db_name] [LIKE wild]
6 or SHOW STATUS [LIKE wild]
7 or SHOW VARIABLES [LIKE wild]
8 or SHOW LOGS
9 or SHOW [FULL] PROCESSLIST
10 or SHOW GRANTS FOR user
11 or SHOW CREATE TABLE table_name
12 or SHOW MASTER STATUS
13 or SHOW MASTER LOGS
14 or SHOW SLAVE STATUS
15 or SHOW WARNINGS [LIMIT #]
16 or SHOW ERRORS [LIMIT #]
17 or SHOW TABLE TYPES
18 SHOW provides information
2 or SHOW [OPEN] TABLES [FROM db_name] [LIKE wild]
3 or SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE wild]
4 or SHOW INDEX FROM tbl_name [FROM db_name]
5 or SHOW TABLE STATUS [FROM db_name] [LIKE wild]
6 or SHOW STATUS [LIKE wild]
7 or SHOW VARIABLES [LIKE wild]
8 or SHOW LOGS
9 or SHOW [FULL] PROCESSLIST
10 or SHOW GRANTS FOR user
11 or SHOW CREATE TABLE table_name
12 or SHOW MASTER STATUS
13 or SHOW MASTER LOGS
14 or SHOW SLAVE STATUS
15 or SHOW WARNINGS [LIMIT #]
16 or SHOW ERRORS [LIMIT #]
17 or SHOW TABLE TYPES
18 SHOW provides information