一些延伸到表演执行情况的陈述Information_Schema.：

Information_Schema.是一个信息数据库，因此它的名称包含在输出中显示数据库。相似地，显示表格可以使用Information_Schema.要获取其表列表：

MySQL>从Information_Schema的表显示表格;+ ---------------------------------- + |tables_in_information_schema |+ ---------------------------------- + |character_sets ||整理||collat​​ion_character_set_applicability || COLUMNS | | COLUMN_PRIVILEGES | | ENGINES | | EVENTS | | FILES | | KEY_COLUMN_USAGE | | PARTITIONS | | PLUGINS | | PROCESSLIST | | REFERENTIAL_CONSTRAINTS | | ROUTINES | | SCHEMATA | | SCHEMA_PRIVILEGES | | STATISTICS | | TABLES | | TABLE_CONSTRAINTS | | TABLE_PRIVILEGES | | TRIGGERS | | USER_PRIVILEGES | | VIEWS | +---------------------------------------+

显示列和描述可以显示有关个体列中的列的信息Information_Schema.表。

表演接受一个的陈述喜欢子句限制显示的行也允许在哪里子句指定所选行必须满足的更多一般条件：

Show Charmase Show Collat​​ion Collat​​ion Shows列表显示功能状态显示索引显示打开表显示程序状态显示状态显示状态显示状态显示表显示触发触发显示变量

这在哪里子句如果存在，则根据由表演陈述。例如，显示字符集语句会产生这些输出列：

mysql> show character set;+ ---------- + --------------------------------------------- + -------- + |charset |描述|默认排序规则|maxlen |+ ---------- + --------------------------------------------- + -------- + |big5 |Big5繁体中文|big5_chinese_ci | 2 | | dec8 | DEC West European | dec8_swedish_ci | 1 | | cp850 | DOS West European | cp850_general_ci | 1 | | hp8 | HP West European | hp8_english_ci | 1 | | koi8r | KOI8-R Relcom Russian | koi8r_general_ci | 1 | | latin1 | cp1252 West European | latin1_swedish_ci | 1 | | latin2 | ISO 8859-2 Central European | latin2_general_ci | 1 | ...

用A.在哪里条款与显示字符集，您将引用这些列名称。作为示例，以下语句显示有关默认排序规则包含字符串的字符集的信息'日本人'：

mysql>显示字符集，其中`默认排序规则（如'％日语％'）;+ --------- + ------------------------------------------ + -------- + |charset |描述|默认排序规则|maxlen |+ --------- + ------------------------------------------ + -------- + |Ujis |EUC-JP日语|ujis_japanese_ci | 3 | | sjis | Shift-JIS Japanese | sjis_japanese_ci | 2 | | cp932 | SJIS for Windows Japanese | cp932_japanese_ci | 2 | | eucjpms | UJIS for Windows Japanese | eucjpms_japanese_ci | 3 | +---------+---------------------------+---------------------+--------+

此语句显示多字节字符集：

mysql>显示maxlen> 1的字符集;+ --------- + ------------------------------------------ + -------- + |charset |描述|默认排序规则|maxlen |+ --------- + ------------------------------------------ + -------- + |big5 |Big5繁体中文|big5_chinese_ci | 2 | | ujis | EUC-JP Japanese | ujis_japanese_ci | 3 | | sjis | Shift-JIS Japanese | sjis_japanese_ci | 2 | | euckr | EUC-KR Korean | euckr_korean_ci | 2 | | gb2312 | GB2312 Simplified Chinese | gb2312_chinese_ci | 2 | | gbk | GBK Simplified Chinese | gbk_chinese_ci | 2 | | utf8 | UTF-8 Unicode | utf8_general_ci | 3 | | ucs2 | UCS-2 Unicode | ucs2_general_ci | 2 | | cp932 | SJIS for Windows Japanese | cp932_japanese_ci | 2 | | eucjpms | UJIS for Windows Japanese | eucjpms_japanese_ci | 3 | +---------+---------------------------+---------------------+--------+