(mysql.info) show
Info Catalog
(mysql.info) set-option
(mysql.info) database-administration-statements
(mysql.info) other-administrative-sql
13.5.4 `SHOW' Syntax
--------------------
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-procedure `SHOW CREATE PROCEDURE' and `SHOW CREATE FUNCTION' Syntax
* show-create-table `SHOW CREATE TABLE' Syntax
* show-create-view `SHOW CREATE VIEW' Syntax
* show-databases `SHOW DATABASES' Syntax
* show-engine `SHOW ENGINE' 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-open-tables `SHOW OPEN TABLES' Syntax
* show-privileges `SHOW PRIVILEGES' Syntax
* show-procedure-status `SHOW PROCEDURE STATUS' and `SHOW FUNCTION STATUS' Syntax
* show-processlist `SHOW PROCESSLIST' Syntax
* show-status `SHOW STATUS' Syntax
* show-table-status `SHOW TABLE STATUS' Syntax
* show-tables `SHOW TABLES' Syntax
* show-triggers `SHOW TRIGGERS' Syntax
* show-variables `SHOW VARIABLES' Syntax
* show-warnings `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 [FULL] COLUMNS FROM TBL_NAME [FROM DB_NAME] [LIKE 'PATTERN']
SHOW CREATE DATABASE DB_NAME
SHOW CREATE FUNCTION FUNCNAME
SHOW CREATE PROCEDURE PROCNAME
SHOW CREATE TABLE TBL_NAME
SHOW DATABASES [LIKE 'PATTERN']
SHOW ENGINE ENGINE_NAME {LOGS | STATUS }
SHOW [STORAGE] ENGINES
SHOW ERRORS [LIMIT [OFFSET,] ROW_COUNT]
SHOW FUNCTION STATUS [LIKE 'PATTERN']
SHOW GRANTS FOR USER
SHOW INDEX FROM TBL_NAME [FROM DB_NAME]
SHOW INNODB STATUS
SHOW PROCEDURE STATUS [LIKE 'PATTERN']
SHOW [BDB] LOGS
SHOW PRIVILEGES
SHOW [FULL] PROCESSLIST
SHOW [GLOBAL | SESSION] STATUS [LIKE 'PATTERN']
SHOW TABLE STATUS [FROM DB_NAME] [LIKE 'PATTERN']
SHOW [OPEN] TABLES [FROM DB_NAME] [LIKE 'PATTERN']
SHOW TRIGGERS
SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'PATTERN']
SHOW WARNINGS [LIMIT [OFFSET,] ROW_COUNT]
The `SHOW' statement also has forms that provide information about
replication-sql:::
SHOW BINLOG EVENTS
SHOW MASTER LOGS
SHOW MASTER STATUS
SHOW SLAVE HOSTS
SHOW SLAVE STATUS
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
extended-show.
Info Catalog
(mysql.info) set-option
(mysql.info) database-administration-statements
(mysql.info) other-administrative-sql
automatically generated byinfo2html