13.7.5 SHOW Syntax

13.7.5.1 SHOW AUTHORS Syntax
13.7.5.2 SHOW BINARY LOGS Syntax
13.7.5.3 SHOW BINLOG EVENTS Syntax
13.7.5.4 SHOW CHARACTER SET Syntax
13.7.5.5 SHOW COLLATION Syntax
13.7.5.6 SHOW COLUMNS Syntax
13.7.5.7 SHOW CONTRIBUTORS Syntax
13.7.5.8 SHOW CREATE DATABASE Syntax
13.7.5.9 SHOW CREATE EVENT Syntax
13.7.5.10 SHOW CREATE FUNCTION Syntax
13.7.5.11 SHOW CREATE PROCEDURE Syntax
13.7.5.12 SHOW CREATE TABLE Syntax
13.7.5.13 SHOW CREATE TRIGGER Syntax
13.7.5.14 SHOW CREATE VIEW Syntax
13.7.5.15 SHOW DATABASES Syntax
13.7.5.16 SHOW ENGINE Syntax
13.7.5.17 SHOW ENGINES Syntax
13.7.5.18 SHOW ERRORS Syntax
13.7.5.19 SHOW EVENTS Syntax
13.7.5.20 SHOW FUNCTION CODE Syntax
13.7.5.21 SHOW FUNCTION STATUS Syntax
13.7.5.22 SHOW GRANTS Syntax
13.7.5.23 SHOW INDEX Syntax
13.7.5.24 SHOW INNODB STATUS Syntax
13.7.5.25 SHOW MASTER STATUS Syntax
13.7.5.26 SHOW OPEN TABLES Syntax
13.7.5.27 SHOW PLUGINS Syntax
13.7.5.28 SHOW PRIVILEGES Syntax
13.7.5.29 SHOW PROCEDURE CODE Syntax
13.7.5.30 SHOW PROCEDURE STATUS Syntax
13.7.5.31 SHOW PROCESSLIST Syntax
13.7.5.32 SHOW PROFILE Syntax
13.7.5.33 SHOW PROFILES Syntax
13.7.5.34 SHOW SCHEDULER STATUS Syntax
13.7.5.35 SHOW SLAVE HOSTS Syntax
13.7.5.36 SHOW SLAVE STATUS Syntax
13.7.5.37 SHOW STATUS Syntax
13.7.5.38 SHOW TABLE STATUS Syntax
13.7.5.39 SHOW TABLES Syntax
13.7.5.40 SHOW TRIGGERS Syntax
13.7.5.41 SHOW VARIABLES Syntax
13.7.5.42 SHOW WARNINGS Syntax

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

SHOW AUTHORS
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 CONTRIBUTORS
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 INNODB STATUS
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 SCHEDULER STATUS
SHOW SLAVE HOSTS
SHOW SLAVE STATUS
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 20.27, “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 21, 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 20, INFORMATION_SCHEMA Tables.