MySQL SHOW命令使用详解

SHOW AUTHORS

显示MYSQL开发者信息

SHOW AUTHORS;

SHOW CHARACTER SET

显示服务器当前支持的字符集

SHOW CHARACTER SET;
SHOW CHARACTER SET 'latin%';

SHOW COLLATION

显示所有字符集的排序方式

SHOW COLLATION;
SHOW COLLATION LIKE 'utf8%';

SHOW COLUMNS

显示给定数据表(或视图)的数据列

SHOW COLUMNS FROM tb_name;
SHOW COLUMNS FROM tb_name FROM db_name;
SHOW COLUMNS FROM db_name.tb_name;

SHOW CREATE

显示给定条件的CREATE语句

SHOW CREATE DATABASE [IF NOT EXISTS] db_name;
SHOW CREATE EVENT event_name;
SHOW CREATE FUNCTION func_name;
SHOW CREATE PROCEDURE proc_name;
SHOW CREATE TABLE tb_name ;
SHOW CREATE VIEW view_name;

SHOW DATABASES

显示在MySQL服务器主机上的数据库

SHOW DATABASES;
SHOW DATABASES LIKE 'db_name%'

SHOW ENGINE

显示存储引擎的日志或状态信息。

SHOW ENGINE BDB LOGS;
SHOW ENGINE INNODB STATUS;

SHOW ENGINES

显示服务器当前支持使用的存储引擎

SHOW ENGINES;

SHOW ERRORS

显示一条语句执行而导致的出错信息

SHOW ERRORS;
SHOW COUNT(*) ERRORS;

SHOW EVENTS

显示关于默认数据库里的事件信息

SHOW EVENTS;
SHOW EVENTS FROM event_name;
SHOW EVENTS LIKE 'pattern';
SHOW EVENTS WHERE where_expr;

SHOW ENGINE INNODB MUTEX

显示关于InnoDB互斥锁定机制的信息

SHOW ENGINE INNODB MUTEX;

SHOW GRANTS

显示给定用户的访问权限

SHOW GRANTS FOR 'user_name'@'host_name';
SHOW GRANTS FOR ''@'host_name';

SHOW  INDEX

显示关于给定数据库的索引信息

SHOW INDEX FROM tb_name;
SHOW INDEX FROM tb_name FROM db_name;
SHOW INDEX FROM db_name.tb_name;

SHOW OPEN TABLES

显示一份已在数据表缓存里注册并处于打开状态的非TEMPORARY数据表清单

SHOW OPEN TABLES;
SHOW OPEN TABLES FROM db_name;
SHOW OPEN TABLES IN db_name;
SHOW OPEN TABLES LIKE 'pattern';
SHOW OPEN TABLE WHERE where_expr;

SHOW PRIVILEGES

显示可以由你授权的权限以及含义

SHOW PRIVILEGES;

SHOW PROCESSLIST

显示当前正在执行的服务器活动的信息

SHOW PROCESSLIST;

SHOW SLAVE STATUS

显示服务器的复制工作状态

SHOW SLAVE STATUS;

SHOW STATUS

显示服务器的状态变量和值

SHOW STATUS;

SHOW TABLE STATUS

显示给定数据表的描述性信息

SHOW TABLE STATUS;
SHOW TABLE STATUS FROM db_name;
SHOW TABLE STATUS IN db_name;
SHOW TABLE STATUS LIKE 'pattern';
SHOW TABLE STATUS WHERE where_expr;

SHOW TABLES

显示给定数据库里的非'TEMPORARY'数据库的名字

SHOW TABLES;
SHOW TABLES FROM db_name;
SHOW TABLES IN db_name;
SHOW TABLES LIKE 'pattern';
SHOW TABLES WHERE where_expr;

SHOW TRIGGERS

显示默认数据库里的触发器的信息

SHOW TRIGGERS;
SHOW TRIGGERS FROM db_name;
SHOW TRIGGERS LIKE 'pattern';
SHOW TRIGGERS WHERE where_expr;

SHOW VARIABLES

显示系统变量和值

SHOW VARIABLES;
SHOW GLOBAL VARIABLES;
SHOW SESSION VARIABLES;
SHOW VARIABLES LIKE 'pattern';
SHOW VARIABLES LIKE 'event_scheduler';
SHOW VARIABLES WHERE where_expr;

SHOW  WARNINGS

显示一条语句执行而导致的出错信息,警告信息或其他提示性信息

SHOW WARNINGS;
SHOW WARNINGS LIMIT show_count;
SHOW COUNT(*) WARNINGS;