MySQL中的show命令用法详解
官方详解
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 | SHOW {BINARY | MASTER} LOGS SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] SHOW {CHARACTER SET | CHARSET} [like_or_where] SHOW COLLATION [like_or_where] SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [like_or_where] SHOW CREATE DATABASE db_name SHOW CREATE EVENT event_name SHOW CREATE FUNCTION func_name SHOW CREATE PROCEDURE proc_name SHOW CREATE TABLE tbl_name SHOW CREATE TRIGGER trigger_name SHOW CREATE VIEW view_name SHOW DATABASES [like_or_where] SHOW ENGINE engine_name {STATUS | MUTEX} SHOW [STORAGE] ENGINES SHOW ERRORS [LIMIT [offset,] row_count] SHOW EVENTS SHOW FUNCTION CODE func_name SHOW FUNCTION STATUS [like_or_where] SHOW GRANTS FOR user SHOW INDEX FROM tbl_name [FROM db_name] SHOW MASTER STATUS SHOW OPEN TABLES [FROM db_name] [like_or_where] SHOW PLUGINS SHOW PROCEDURE CODE proc_name SHOW PROCEDURE STATUS [like_or_where] SHOW PRIVILEGES SHOW [FULL] PROCESSLIST SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n] SHOW PROFILES SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] SHOW {REPLICAS | SLAVE HOSTS} SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] SHOW [GLOBAL | SESSION] STATUS [like_or_where] SHOW TABLE STATUS [FROM db_name] [like_or_where] SHOW [FULL] TABLES [FROM db_name] [like_or_where] SHOW TRIGGERS [FROM db_name] [like_or_where] SHOW [GLOBAL | SESSION] VARIABLES [like_or_where] SHOW WARNINGS [LIMIT [offset,] row_count] like_or_where: { LIKE 'pattern' | WHERE expr } |
13.7.5.1 SHOW BINARY LOGS Statement
13.7.5.2 SHOW BINLOG EVENTS Statement
13.7.5.3 SHOW CHARACTER SET Statement
13.7.5.4 SHOW COLLATION Statement
13.7.5.5 SHOW COLUMNS Statement
13.7.5.6 SHOW CREATE DATABASE Statement
13.7.5.7 SHOW CREATE EVENT Statement
13.7.5.8 SHOW CREATE FUNCTION Statement
13.7.5.9 SHOW CREATE PROCEDURE Statement
13.7.5.10 SHOW CREATE TABLE Statement
13.7.5.11 SHOW CREATE TRIGGER Statement
13.7.5.12 SHOW CREATE USER Statement
13.7.5.13 SHOW CREATE VIEW Statement
13.7.5.14 SHOW DATABASES Statement
13.7.5.15 SHOW ENGINE Statement
13.7.5.16 SHOW ENGINES Statement
13.7.5.17 SHOW ERRORS Statement
13.7.5.18 SHOW EVENTS Statement
13.7.5.19 SHOW FUNCTION CODE Statement
13.7.5.20 SHOW FUNCTION STATUS Statement
13.7.5.21 SHOW GRANTS Statement
13.7.5.22 SHOW INDEX Statement
13.7.5.23 SHOW MASTER STATUS Statement
13.7.5.24 SHOW OPEN TABLES Statement
13.7.5.25 SHOW PLUGINS Statement
13.7.5.26 SHOW PRIVILEGES Statement
13.7.5.27 SHOW PROCEDURE CODE Statement
13.7.5.28 SHOW PROCEDURE STATUS Statement
13.7.5.29 SHOW PROCESSLIST Statement
13.7.5.30 SHOW PROFILE Statement
13.7.5.31 SHOW PROFILES Statement
13.7.5.32 SHOW RELAYLOG EVENTS Statement
13.7.5.33 SHOW SLAVE HOSTS Statement
13.7.5.34 SHOW SLAVE STATUS Statement
13.7.5.35 SHOW STATUS Statement
13.7.5.36 SHOW TABLE STATUS Statement
13.7.5.37 SHOW TABLES Statement
13.7.5.38 SHOW TRIGGERS Statement
13.7.5.39 SHOW VARIABLES Statement
13.7.5.40 SHOW WARNINGS Statement
参考
https://dev.mysql.com/doc/refman/5.6/en/show.html
