SHOW 可以以各种形式描述数据库系统的信息，诸如数据表，字段，服务器状态等等。大致有以下这些方法：+S i,Z k M y m [ u0

v [$e"X [!a r!^ c7?'l0SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE 'pattern'] \\显示表的字段定义51Testing软件测试网"}*m W Y h o {#A
SHOW CREATE DATABASE db_name \\显示数据库定义51Testing软件测试网3w b ^ X+T R }
SHOW CREATE TABLE tbl_name \\显示表定义51Testing软件测试网 p d J `!K&l f ?
SHOW DATABASES [LIKE 'pattern'] \\显示数据库列表
'a C+o1w L j8P1Y0SHOW [STORAGE] ENGINES \\显示存储引擎的支持情况51Testing软件测试网 r c#B.A'E-s:S)K
SHOW ERRORS [LIMIT [offset,] row_count] \\显示最后一个执行语句所产生的错误51Testing软件测试网 b$| r ?+_ i ^#F
SHOW GRANTS FOR user \\显示用户的权限
m#r I-`1s ~9r c;Z0SHOW INDEX FROM tbl_name [FROM db_name] \\显示表索引列表51Testing软件测试网'h6n"N5x u |1i R d"g7P
SHOW INNODB STATUS \\显示innoDB存储引擎的状态51Testing软件测试网 K y!E V6G9^
SHOW [BDB] LOGS \\显示BDB存储引擎的日志
c,F&j O w.B:] B5r E0SHOW PRIVILEGES \\显示支持的权限及定义51Testing软件测试网&K(G:f:p t x W,U r
SHOW [FULL] PROCESSLIST \\显示系统中正在运行的所有进程，也就是当前正在执行的查询51Testing软件测试网 X X$R1z P p h"i,q Q
SHOW STATUS [LIKE 'pattern'] \\显示一些系统特定资源的信息，例如，正在运行的线程数量
v ^&A8[ |*H.m N:M0SHOW TABLE STATUS [FROM db_name] [LIKE 'pattern'] \\显示当前使用或者指定的database中的每个表的信息
q;b S N"K2] n0SHOW [OPEN] TABLES [FROM db_name] [LIKE 'pattern'] \\显示当前database的所有表
L G a+X | y k B W0SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern'] \\显示系统变量的名称和值
-v,G H |"u w0SHOW WARNINGS [LIMIT [offset,] row_count] \\显示最后一个执行的语句所产生的错误、警告和通知51Testing软件测试网't z8h N Y3h!x"J-T

51Testing软件测试网 k:E P/@ v%~ ~

如果 SHOW 语法中包括 LIKE 'pattern' 分句的话，'pattern' 是一个可以包括 SQL 语法中‘ % '和‘ _ '等通配符的字符串。这个模式语句对于取得相应的结果十分有用。

V P8w!X P.t V051Testing软件测试网:a2Q9{ t g7}3P'h

请注意，还有以下几种不同的标识方式：51Testing软件测试网4i v X {0u7D5O

51Testing软件测试网&x K U1q/e4p D9v

SHOW 语句有以下几种方式用于描述复制主服务器和从服务器的信息：

&n"q&_7U N/x6_051Testing软件测试网 w0g5S7| L&P

SHOW BINLOG EVENTS
5@1_$j4w!G K b e8m g:v0SHOW MASTER LOGS
8X G `5m'Z0SHOW MASTER STATUS
4J(d R d4q-h { ],W"a0SHOW SLAVE HOSTS
z j%v!V J6R7G \0SHOW SLAVE STATUS

F l C f c w V0

O k h k h |0其他:51Testing软件测试网 L b&B v,Z u.p G v
51Testing软件测试网 l8a Q F e4L*d \
? contents \\MySQL帮助,可以查询

mysql> ? contents
You asked for help about help category: "Contents"
For more information, type 'help <item>', where <item> is one of the following
categories:
   Account Management
   Administration
   Data Definition
   Data Manipulation
   Data Types
   Functions
   Functions and Modifiers for Use with GROUP BY
   Geographic Features
   Language Structure
   Storage Engines
   Stored Routines
   Table Maintenance
   Transactions
   Triggers
   Utility

mysql> ? Data Definition
You asked for help about help category: "Data Definition"
For more information, type 'help <item>', where <item> is one of the following
topics:
   ALTER DATABASE
   ALTER TABLE
   ALTER VIEW
   CONSTRAINT
   CREATE DATABASE
   CREATE INDEX
   CREATE TABLE
   CREATE VIEW
   DROP DATABASE
   DROP INDEX
   DROP TABLE
   DROP VIEW
   MERGE
   RENAME TABLE

mysql> ? Data Manipulation
You asked for help about help category: "Data Manipulation"
For more information, type 'help <item>', where <item> is one of the following
topics:
   CACHE INDEX
   CHANGE MASTER TO
   DEALLOCATE PREPARE
   DELETE
   DO
   DUAL
   EXECUTE STATEMENT
   FLUSH
   HANDLER
   INSERT
   INSERT DELAYED
   INSERT SELECT
   JOIN
   KILL
   LOAD DATA
   LOAD DATA FROM MASTER
   LOAD INDEX
   LOAD TABLE FROM MASTER
   PREPARE
   PURGE MASTER LOGS
   REPLACE INTO
   RESET
   RESET MASTER
   RESET SLAVE
   SELECT
   SET
   SET GLOBAL SQL_SLAVE_SKIP_COUNTER
   SET SQL_LOG_BIN
   SHOW
   SHOW BINARY LOGS
   SHOW BINLOG EVENTS
   SHOW CHARACTER SET
   SHOW COLLATION
   SHOW COLUMNS
   SHOW CREATE DATABASE
   SHOW CREATE PROCEDURE
   SHOW CREATE TABLE
   SHOW CREATE VIEW
   SHOW DATABASES
   SHOW ENGINE
   SHOW ENGINES
   SHOW ERRORS
   SHOW GRANTS
   SHOW INDEX
   SHOW INNODB STATUS
   SHOW LOGS
   SHOW MASTER STATUS
   SHOW MUTEX STATUS
   SHOW OPEN TABLES
   SHOW PRIVILEGES
   SHOW PROCEDURE CODE
   SHOW PROCEDURE STATUS
   SHOW PROCESSLIST
   SHOW PROFILES
   SHOW SLAVE HOSTS
   SHOW SLAVE STATUS
   SHOW STATUS
   SHOW TABLE STATUS
   SHOW TABLES
   SHOW TRIGGERS
   SHOW VARIABLES
   SHOW WARNINGS
   START SLAVE
   STOP SLAVE
   TRUNCATE TABLE
   UNION
   UPDATE

mysql> ? Data Types
You asked for help about help category: "Data Types"
For more information, type 'help <item>', where <item> is one of the following
topics:
   AUTO_INCREMENT
   BIGINT
   BINARY
   BIT
   BLOB
   BLOB DATA TYPE
   BOOLEAN
   CHAR
   CHAR BYTE
   DATE
   DATETIME
   DEC
   DECIMAL
   DOUBLE
   DOUBLE PRECISION
   ENUM
   FLOAT
   INT
   INTEGER
   LONGBLOB
   LONGTEXT
   MEDIUMBLOB
   MEDIUMINT
   MEDIUMTEXT
   SET DATA TYPE
   SMALLINT
   TEXT
   TIME
   TIMESTAMP
   TINYBLOB
   TINYINT
   TINYTEXT
   VARBINARY
   VARCHAR
   YEAR DATA TYPE

? select用法等

? insert

6~ p w [ Q D Z N051Testing软件测试网%]%T"M @;Q*y*b LEXPLAIN [EXTENDED] SELECT select_options \\显示MySQL如何处理Select语句,显示用到的索引等,具体查看帮助