(mysql.info.gz) SHOW
Info Catalog
(mysql.info.gz) SET OPTION
(mysql.info.gz) Database Administration
(mysql.info.gz) Other administrative SQL
13.5.4 `SHOW' Syntax
--------------------
`SHOW' has many forms that provide information about databases, tables,
columns, or status information about the server. This section
describes those following:
SHOW [FULL] COLUMNS FROM TBL_NAME [FROM DB_NAME] [LIKE 'PATTERN']
SHOW CREATE DATABASE DB_NAME
SHOW CREATE TABLE TBL_NAME
SHOW DATABASES [LIKE 'PATTERN']
SHOW [STORAGE] ENGINES
SHOW ERRORS [LIMIT [OFFSET,] ROW_COUNT]
SHOW GRANTS FOR USER
SHOW INDEX FROM TBL_NAME [FROM DB_NAME]
SHOW INNODB STATUS
SHOW [BDB] LOGS
SHOW PRIVILEGES
SHOW [FULL] PROCESSLIST
SHOW STATUS [LIKE 'PATTERN']
SHOW TABLE STATUS [FROM DB_NAME] [LIKE 'PATTERN']
SHOW [OPEN] TABLES [FROM DB_NAME] [LIKE 'PATTERN']
SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'PATTERN']
SHOW WARNINGS [LIMIT [OFFSET,] ROW_COUNT]
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.
Note that there are other forms of these statements described elsewhere:
* The `SHOW' statement has forms that provide information about
replication master and slave servers:
SHOW BINLOG EVENTS
SHOW MASTER LOGS
SHOW MASTER STATUS
SHOW SLAVE HOSTS
SHOW SLAVE STATUS
These forms of `SHOW' are described in Replication SQL.
Menu
* SHOW CHARACTER SET `SHOW CHARACTER SET' Syntax
* SHOW COLLATION `SHOW COLLATION' Syntax
* SHOW COLUMNS `SHOW COLUMNS' Syntax
* SHOW CREATE DATABASE `SHOW CREATE DATABASE' Syntax
* SHOW CREATE TABLE `SHOW CREATE TABLE' Syntax
* SHOW CREATE VIEW `SHOW CREATE VIEW' Syntax
* SHOW DATABASES `SHOW DATABASES' Syntax
* SHOW ENGINES `SHOW ENGINES' Syntax
* SHOW ERRORS `SHOW ERRORS' Syntax
* SHOW GRANTS `SHOW GRANTS' Syntax
* SHOW INDEX `SHOW INDEX' Syntax
* SHOW INNODB STATUS `SHOW INNODB STATUS' Syntax
* SHOW LOGS `SHOW LOGS' Syntax
* SHOW PRIVILEGES `SHOW PRIVILEGES' Syntax
* SHOW PROCESSLIST `SHOW PROCESSLIST' Syntax
* SHOW STATUS `SHOW STATUS' Syntax
* SHOW TABLE STATUS `SHOW TABLE STATUS' Syntax
* SHOW TABLES `SHOW TABLES' Syntax
* SHOW VARIABLES `SHOW VARIABLES' Syntax
* SHOW WARNINGS `SHOW WARNINGS' Syntax
Info Catalog
(mysql.info.gz) SET OPTION
(mysql.info.gz) Database Administration
(mysql.info.gz) Other administrative SQL
automatically generated byinfo2html