合 MySQL中的show命令用法详解
👉 本文共约2413个字，系统预计阅读时间或需10分钟。
官方详解
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
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
