MYSQL查看及修改表使用的存储引擎_MySQL

bitsCN.com
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 | +------+--------+---------+------------+------+----------------+-------------+-----------------+ 不正确的方法： 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引擎，所以不准确。 修改： alter table table_name engine=innodb; alter table table_name engine=myisam; bitsCN.com