可能重复:
如何检查特定表的MySQL引擎类型?
除了show create table table_name
和show status
之外,获取表引擎的查询是什么?
对于一个表:
SELECT table_name,engine FROM INFORMATION_SCHEMA.TABLES
WHERE table_name='table_name';
对于模式中的所有表:
SELECT table_name,engine FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema='schema_name';
以相同模式登录时:
SELECT table_name,engine FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema=DATABASE();
SHOW TABLE STATUS [{FROM | IN} db_name]
[LIKE 'pattern' | WHERE expr]
http://dev.mysql.com/doc/refman/5.1/en/show-table-status.html