- 查看支持的字符集
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
网友评论