如何快速查询表的引擎类型

作者: Huang Jinqiang 分类: Database 发布时间: 2016-11-30 17:23

(product)root@localhost [planx]> SELECT table_name, engine FROM information_schema.tables WHERE table_schema = 'operation' ORDER BY table_name DESC;
+-------------+--------+
| table_name | engine |
+-------------+--------+
| t_instances | InnoDB |
+-------------+--------+
1 row in set (0.00 sec)

发表评论

电子邮件地址不会被公开。 必填项已用*标注