- 查看某类型的详细，比如查库、查表、查索引、查事件、查功能、查存储过程、查触发器、查用户、查视图
mysql>SHOW CREATE DATABASE mysql\G
Database: mysql
Create Database: CREATE DATABASE `mysql` /*!40100 DEFAULT CHARACTER SET utf8 */
1 row in set (0.00 sec)
mysql> SHOW CREATE TABLE t\G
Table: t
Create Table: CREATE TABLE `t` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`s` char(60) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
mysql> SHOW INDEX FROM mysql.user;
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| user | 0 | PRIMARY | 1 | Host | A | NULL | NULL | NULL | | BTREE | |
| user | 0 | PRIMARY | 2 | User | A | 26 | NULL | NULL | | BTREE | |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
2 rows in set (0.00 sec)
同类：
SHOW CREATE EVENT event_name;
SHOW CREATE FUNCTION func_name;
SHOW CREATE PROCEDURE proc_name;
SHOW CREATE TRIGGER trigger_name;
SHOW CREATE USER user;
SHOW CREATE VIEW view_name;
2. 查某一容器中的信息,比如查所有库、所有表、查所有引擎、查所有错误、查所有事件、查权限、查触发器、查所有参数
SHOW DATABASES\G
>同类：
SHOW ENGINES\G
SHOW ERRORS\G
SHOW EVENTS\G
SHOW PRIVILEGES\G
SHOW TRIGGERS \G
SHOW VARIABLES\G
3. 查某一状态，如查进程、系统参数状态、查表的状态、master状态、slave状态、查打开的表、查存储过程的状态
SHOW PROCESSLIST;
SHOW STATUS;
SHOW TABLE STATUS;
>同类：
SHOW MASTER STATUS\G
SHOW SLAVE STATUS\G
SHOW OPEN TABLES;
SHOW PROCEDURE STATUS\G