MySQL SHOW

1. 查看某类型的详细，比如查库、查表、查索引、查事件、查功能、查存储过程、查触发器、查用户、查视图

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