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

SHOW BINARY LOG STATUS
SHOW BINARY 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 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 REPLICA STATUS [FOR CHANNEL channel]
SHOW REPLICAS
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
}

如果给定的语法 SHOW 语句包含 LIKE 'pattern' 部分，'pattern' 是一个字符串，可以包含 SQL % 和 _ 个万用字符。该模式有助于限制语句输出为匹配值。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. The pattern is useful for restricting statement output to matching values.

几个SHOW语句也接受一个WHERE子句，该子句在指定显示哪些行时提供更多的灵活性。参见第 28.8 节，“SHOW 语句的扩展”.Several SHOW statements also accept a WHERE clause that provides more flexibility in specifying which rows to display. See Section 28.8, “Extensions to SHOW Statements”.

在 SHOW 语句结果，用户名和主机名使用回溯引号（'）引用。In SHOW statement results, user names and host names are quoted using backticks (`).

许多 MySQL API（如 PHP）允许你将SHOW 语句的结果集，视为SELECT;更多信息请参见 Chapter 31，Connectors and APIs，或你的 API 文档。此外，你还可以用 SQL 处理 INFORMATION_SCHEMA 数据库中对表查询的结果，这在 SHOW的。参见 Chapter 28， INFORMATION_SCHEMA Tables“的结果是不容易实现的。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 31, Connectors and APIs, or your API documentation for more information. 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. See Chapter 28, INFORMATION_SCHEMA Tables.