SHOW has many forms that provide information about databases, tables, columns, or status information about the server. SHOW有许多形式，提供有关数据库、表、列的信息或有关服务器的状态信息。This section describes those following:本节介绍了以下内容：

SHOW {BINARY | MASTER} LOGS
SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
SHOW CHARACTER SET [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
}

If the syntax for a given SHOW statement includes a LIKE 'pattern' part, 'pattern' is a string that can contain the SQL % and _ wildcard characters. 如果给定SHOW语句的语法包含LIKE 'pattern'部分，则'pattern'是一个可以包含SQL%和_通配符的字符串。The pattern is useful for restricting statement output to matching values.该模式用于将语句输出限制为匹配值。

Several SHOW statements also accept a WHERE clause that provides more flexibility in specifying which rows to display. 一些SHOW语句还接受WHERE子句，该子句在指定要显示的行时提供了更大的灵活性。See Section 26.8, “Extensions to SHOW Statements”.请参阅第26.8节，“SHOW语句的扩展”。

Many MySQL APIs (such as PHP) enable you to treat the result returned from a SHOW statement as you would a result set from a SELECT; see Chapter 29, Connectors and APIs, or your API documentation for more information. 许多MySQL API（如PHP）允许您将SHOW语句返回的结果视为SELECT语句的结果集；有关更多信息，请参阅第29章，“连接器和API”或API文档。In addition, you can work in SQL with results from queries on tables in the INFORMATION_SCHEMA database, which you cannot easily do with results from SHOW statements. 此外，您还可以在SQL中处理对INFORMATION_SCHEMA数据库中的表进行查询的结果，而这对于SHOW语句的结果来说是不容易做到的。See Chapter 26, INFORMATION_SCHEMA Tables.请参阅第26章，“INFORMATION_SCHEMA表”。