(mysql.info)SHOW


`SHOW' Syntax
-------------

        SHOW DATABASES [LIKE wild]
     or SHOW [OPEN] TABLES [FROM db_name] [LIKE wild]
     or SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE wild]
     or SHOW INDEX FROM tbl_name [FROM db_name]
     or SHOW TABLE STATUS [FROM db_name] [LIKE wild]
     or SHOW STATUS [LIKE wild]
     or SHOW VARIABLES [LIKE wild]
     or SHOW LOGS
     or SHOW [FULL] PROCESSLIST
     or SHOW GRANTS FOR user
     or SHOW CREATE TABLE table_name
     or SHOW MASTER STATUS
     or SHOW MASTER LOGS
     or SHOW SLAVE STATUS

`SHOW' provides information about databases, tables, columns, or status
information about the server. If the `LIKE wild' part is used, the
`wild' string can be a string that uses the SQL `%' and `_' wild-card
characters.

SHOW DATABASE INFO: Retrieving information about Database, Tables, Columns, and Indexes
SHOW TABLE STATUS: `SHOW TABLE STATUS'
SHOW STATUS: `SHOW STATUS'
SHOW VARIABLES: `SHOW VARIABLES'
SHOW LOGS: `SHOW LOGS'
SHOW PROCESSLIST: `SHOW PROCESSLIST'
SHOW GRANTS: `SHOW GRANTS'
SHOW CREATE TABLE: `SHOW CREATE TABLE'

automatically generated by info2www version 1.2.2.9