13.7.5 SHOW Statements

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

SHOW has many forms that provide information about databases, tables, columns, or status information about the server. This section describes those following:

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 SLAVE HOSTS
SHOW 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. 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. See Section 24.8, “Extensions to SHOW Statements”.

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 27, 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 24, INFORMATION_SCHEMA Tables.