一些扩展显示的实现伴随着语句INFORMATION_SCHEMA：

INFORMATION_SCHEMA是一个信息数据库，因此它的名称包含在从显示数据库．同样的,显示表可与INFORMATION_SCHEMA获取其表的列表:

mysql>显示信息表+---------------------------------------+ | Tables_in_INFORMATION_SCHEMA  | +---------------------------------------+ | 列CHARACTER_SETS | | |排序| COLLATION_CHARACTER_SET_APPLICABILITY | | | | COLUMN_PRIVILEGES | |引擎| |事件| |文件| | GLOBAL_STATUS | | GLOBAL_VARIABLES | | KEY_COLUMN_USAGE | |分区| |插件| | PROCESSLIST | | REFERENTIAL_CONSTRAINTS | |例程| |图式| | SCHEMA_PRIVILEGES | | SESSION_STATUS | | SESSION_VARIABLES | |统计| |表| | TABLE_CONSTRAINTS | | TABLE_PRIVILEGES | |触发| | USER_PRIVILEGES | |视图  | +---------------------------------------+

显示列而且描述是否可以单独显示有关列的信息INFORMATION_SCHEMA表。

显示的语句。就像子句来限制所显示的行，也允许在哪里子句，指定所选行必须满足的更一般的条件:

Show character set Show collation Show columns Show databases Show function status Show index Show open tables Show procedure status Show status Show table status Show tables Show触发器Show变量

的在哪里子句，则根据控件显示的列名求值显示声明。例如，显示字符集语句生成以下输出列:

mysql>显示字符集+----------+-----------------------------+---------------------+--------+ | 字符集| |描述默认排序| Maxlen  | +----------+-----------------------------+---------------------+--------+ | 繁体中国传统| |繁体big5_chinese_ci | 2 | | dec8 | 12月西欧| dec8_swedish_ci | 1 | | cp850西欧| | DOS cp850_general_ci | 1 | | hp8西欧| |惠普hp8_english_ci | 1 | | koi8r | KOI8-R俄罗斯列尔科姆网| koi8r_general_ci | 1 | | latin1 |中的一个cp1252西方欧洲| latin1_swedish_ci | 1 | | latin2 | ISO 8859-2中欧| latin2_general_ci | 1 |…

使用在哪里条款与显示字符集，您将引用这些列名。例如，下面的语句显示关于默认排序规则包含字符串的字符集的信息“日本”：

mysql>显示字符集中'默认排序规则'，如'%japanese%'+---------+---------------------------+---------------------+--------+ | 字符集| |描述默认排序| Maxlen  | +---------+---------------------------+---------------------+--------+ | 里头| EUC-JP日本| ujis_japanese_ci | 3 | | sjis | shift - jis日本| sjis_japanese_ci | 2 | | cp932 | sjis Windows日本| cp932_japanese_ci | 2 | | eucjpms |里头Windows日本| eucjpms_japanese_ci | 3  | +---------+---------------------------+---------------------+--------+

这个语句显示多字节字符集:

mysql>显示字符集+---------+---------------------------+---------------------+--------+ | 字符集| |描述默认排序| Maxlen  | +---------+---------------------------+---------------------+--------+ | 繁体中国传统| |繁体big5_chinese_ci | 2 | |里头| EUC-JP日本| ujis_japanese_ci | 3 | | sjis | shift - jis日本| sjis_japanese_ci | 2 | | euckr | EUC-KR韩国| euckr_korean_ci | 2 | | gb2312 | gb2312简体中文| gb2312_chinese_ci | 2 | | gbk | gbk简体中文| gbk_chinese_ci | 2 | | utf8 | utf - 8的Unicode | utf8_general_ci | 3 | | ucs2 | ucs - 2 Unicode | ucs2_general_ci | 2 | | cp932 | SJIS Windows日本| cp932_japanese_ci | 2 | | eucjpms |里头Windows日本| eucjpms_japanese_ci | 3  | +---------+---------------------------+---------------------+--------+