(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