Mysql ISAM问题

bitterness

我在有些文章中看到所有mysql支持isam
可是我用show variables like 'have%';命令查看时

have_isam             | NO    |
值为NO，请教这是怎么回事呀，

还是我的理解有问题，请指点一下

huifeideluotuo

你可以用这个命令查看你的mysql是否支持 ISAM 引擎 ：show engines;

你理解的没错。

sunnyfun

楼主记错了，MyISAM是默认存储引擎。它基于更老的ISAM代码，但有很多有用的扩展。（注意MySQL 5.1不支持ISAM）。

The original storage engine in MySQL was the ISAM engine. It was the only storage engine available until MySQL 3.23, when the improved MyISAM engine was introduced as the default. ISAM is deprecated. As of MySQL 4.1, it's included in the source but not enabled in binary distributions. It is not available in MySQL 5.0. Embedded MySQL server versions do not support ISAM tables by default.