Shulou(Shulou.com)06/01 Report--

Mysql > help show

Name: 'SHOW'

Description:

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 CODE sp_name

SHOW FUNCTION STATUS [LIKE 'pattern']

SHOW GRANTS FOR user

SHOW INDEX FROM tbl_name [FROM db_name]

SHOW INNODB STATUS

SHOW PROCEDURE CODE sp_name

SHOW PROCEDURE STATUS [LIKE 'pattern']

SHOW [BDB] LOGS

SHOW MUTEX STATUS

SHOW PRIVILEGES

SHOW [FULL] PROCESSLIST

SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n]

SHOW PROFILES

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 master and slave servers and are described in [HELP PURGE

MASTER LOGS]:

SHOW BINARY LOGS

SHOW BINLOG EVENTS

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

Http://dev.mysql.com/doc/refman/5.0/en/extended-show.html.

URL: http://dev.mysql.com/doc/refman/5.0/en/show.html

Each specific show command listed above can also get its help information again:

Mysql > help SHOW INNODB STATUS

Name: 'SHOW INNODB STATUS'

Description:

Syntax:

SHOW INNODB STATUS

In MySQL 5.0, this is a deprecated synonym for SHOW ENGINE INNODB

STATUS. See [HELP SHOW ENGINE].

URL: http://dev.mysql.com/doc/refman/5.0/en/show-innodb-status.html

[@ more@]

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.