如何查找我的表是MyISAM还是Innodb [英] How do I find if my a table is MyISAM or Innodb

问题描述

可能重复:
如何检查特定MySQL引擎的类型桌子?

Possible Duplicate:
How can I check MySQL engine type for a specific table?

假设用户是一个表，执行以下命令不会显示用户表是MyISAM还是Innodb.

Assuming that users is a table following command does not reveal if users table is MyISAM or Innodb.

desc users; 

如何找到用户表的类型?

How do I find what is the type of users table?

推荐答案

您可以使用

You can use SHOW TABLE STATUS to see table information.

SHOW TABLE STATUS WHERE `Name` = 'my_table';

只需检查返回的数据集中的Engine列的值即可知道该表正在使用哪个引擎.

Simply check the value of the Engine column in the returned dataset to know which engine the table is using.

这篇关于如何查找我的表是MyISAM还是Innodb的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！