为什么选innodb
http://www.jianshu.com/p/6b45b150bfbf
mysql下如何更改database下所有表的数据引擎--MyISAM 到InnoDB
http://blog.csdn.net/wangzhaotongalex/article/details/50548258
1.查看当前数据引擎的命令:
2.
ALTER TABLE info_aaaa ENGINE=InnoDB; ALTER TABLE info_data_bbb
ENGINE=InnoDB; ALTER TABLE info_data_ccc ENGINE=InnoDB; ALTER TABLE
info_data_ddd ENGINE=InnoDB; ALTER TABLE info_data_eee
ENGINE=InnoDB; ALTER TABLE info_data_fffENGINE=InnoDB;
再次查看数据表的数据引擎已经更改了:show table status
from
InnoDB
MyISAM
alter table table_name
engine=myisam;