(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