[+/-]
- 13.7.6.1 SHOW BINARY LOGS Syntax
- 13.7.6.2 SHOW BINLOG EVENTS Syntax
- 13.7.6.3 SHOW CHARACTER SET Syntax
- 13.7.6.4 SHOW COLLATION Syntax
- 13.7.6.5 SHOW COLUMNS Syntax
- 13.7.6.6 SHOW CREATE DATABASE Syntax
- 13.7.6.7 SHOW CREATE EVENT Syntax
- 13.7.6.8 SHOW CREATE FUNCTION Syntax
- 13.7.6.9 SHOW CREATE PROCEDURE Syntax
- 13.7.6.10 SHOW CREATE TABLE Syntax
- 13.7.6.11 SHOW CREATE TRIGGER Syntax
- 13.7.6.12 SHOW CREATE USER Syntax
- 13.7.6.13 SHOW CREATE VIEW Syntax
- 13.7.6.14 SHOW DATABASES Syntax
- 13.7.6.15 SHOW ENGINE Syntax
- 13.7.6.16 SHOW ENGINES Syntax
- 13.7.6.17 SHOW ERRORS Syntax
- 13.7.6.18 SHOW EVENTS Syntax
- 13.7.6.19 SHOW FUNCTION CODE Syntax
- 13.7.6.20 SHOW FUNCTION STATUS Syntax
- 13.7.6.21 SHOW GRANTS Syntax
- 13.7.6.22 SHOW INDEX Syntax
- 13.7.6.23 SHOW MASTER STATUS Syntax
- 13.7.6.24 SHOW OPEN TABLES Syntax
- 13.7.6.25 SHOW PLUGINS Syntax
- 13.7.6.26 SHOW PRIVILEGES Syntax
- 13.7.6.27 SHOW PROCEDURE CODE Syntax
- 13.7.6.28 SHOW PROCEDURE STATUS Syntax
- 13.7.6.29 SHOW PROCESSLIST Syntax
- 13.7.6.30 SHOW PROFILE Syntax
- 13.7.6.31 SHOW PROFILES Syntax
- 13.7.6.32 SHOW RELAYLOG EVENTS Syntax
- 13.7.6.33 SHOW SLAVE HOSTS Syntax
- 13.7.6.34 SHOW SLAVE STATUS Syntax
- 13.7.6.35 SHOW STATUS Syntax
- 13.7.6.36 SHOW TABLE STATUS Syntax
- 13.7.6.37 SHOW TABLES Syntax
- 13.7.6.38 SHOW TRIGGERS Syntax
- 13.7.6.39 SHOW VARIABLES Syntax
- 13.7.6.40 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 {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 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
'
part,
pattern
''
is a
string that can contain the SQL pattern
'%
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 25.42, “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 28, 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 25, INFORMATION_SCHEMA Tables.