show语句获取元数据
- show create database test; 数据库
- show create table t_test; 表
- show columns from t_test;表列 等同于desc t_test;
- show index from t_test;索引
字符匹配:
- mysql> show columns from test like 'I%';
- +-------+---------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +-------+---------+------+-----+---------+-------+
- | ID | int(10) | NO | PRI | 0 | |
- +-------+---------+------+-----+---------+-------+
- 1 row in set (0.00 sec)
- mysql> show columns from test where `key` = 'PRI';
- +-------+---------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +-------+---------+------+-----+---------+-------+
- | ID | int(10) | NO | PRI | 0 | |
- +-------+---------+------+-----+---------+-------+
- 1 row in set (0.00 sec)
msyqlshow命令获取
- mysqlshow db_name -uroot -p123456; 数据库
- mysqlshow dbname t_name;表信息
- mysqlshow --status dbname t_name 表状态
- mysqlshow --key dbname t_name 获取索引信息
- mysqlshow --no-datadbname [t_name] 排除不输出datadbname的信息
转载于:https://blog.51cto.com/kexl908/1176087