查看支持的字符集
SHOW CHARACTER SET [LIKE 'pattern']
查看支持的编码
SHOW COLLATION [LIKE 'pattern']
列出表的列信息
SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE 'pattern']
显示create database 语句
SHOW CREATE DATABASE db_name
显示所有数据库名称
SHOW DATABASES [LIKE 'pattern']
查看引擎的相信信息
SHOW ENGINE engine_name {LOGS | STATUS }查看可用的存储引擎和默认引擎
SHOW ENGINES
查看执行语句的错误
SHOW ERRORS [LIMIT [offset,] row_count]
显示用户的权限
SHOW GRANTS FOR user
查看表的索引
SHOW INDEX FROM tbl_name [FROM db_name]
显示master的log
SHOW MASTER LOGS
显示master的状态
SHOW MASTER STATUS
显示服务器支持的权限
SHOW PRIVILEGES
显示slave地址
SHOW SLAVE HOSTS
显示slave状态
SHOW SLAVE STATUS
查看关键字的状态
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]
查看当前表结构的语法
SHOW CREATE TABLE tbl_name
操作线程列表
SHOW [FULL] PROCESSLIST
作者：liuawei
链接：https://www.jianshu.com/p/dadde25edcc8