MYSQL查看及修改表使用的存储引擎
正确的方法：
show table status from db_name where name='table_name';
+------+--------+---------+------------+------+----------------+-------------+-----------------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length |
+---------+------------+------+----------------+-------------+-----------------+--------------+
| t | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 |
+------+--------+---------+------------+------+----------------+-------------+-----------------+
www.2cto.com
不正确的方法：
show create table table_name;
+-------+-----------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+-----------------------------------------------------------------------------------------+
| t | CREATE TABLE `t` (
`
vc` varchar(1) DEFAULT NULL,
`c` char(1) DEFAULT NULL,
KEY `c` (`c`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+------------------------------------------------------------------------------------------+
如果
mysqld没有启动对应的引擎如这里InnoDB，那么会使用默认的MYISAM引擎，所以不准确。
修改： www.2cto.com
alter table table_name engine=innodb;
alter table table_name engine=myisam;