SHOW 命令

显示状态命令,有数据库,表等。

语法:

SHOW DATABASES [LIKE wild]

SHOW [OPEN] TABLES [FROM db_name] [LIKE wild]

SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE wild]

SHOW INDEX FROM tbl_name [FROM db_name]

SHOW TABLE STATUS [FROM db_name] [LIKE wild]

SHOW STATUS [LIKE wild]

SHOW VARIABLES [LIKE wild]

SHOW LOGS

SHOW [FULL] PROCESSLIST

SHOW GRANTS Fuser

SHOW CREATE TABLE table_name

SHOW MASTER STATUS

SHOW MASTER LOGS

SHOW SLAVE STATUS

SHOW WARNINGS [LIMIT #]

SHOW ERRORS [LIMIT #]

SHOW TABLE TYPES