mysql 存储引擎（MyISAM/InnoDB）转换

转换（InnoDb->MyISAM）

CREATE TABLE T_MyISAM LIKE T_InnoDB;
ALTER TABLE T_MyISAM ENGINE = INNODB;
INSERT INTO T_MyISAM SELECT * FROM T_InnoDB;

转换（MyISAM->InnoDb）

数据少的时候可以采用上述方式，数据太多可以采用事务来处理

START TRANSACTION;
INSERT INTO T_InnoDB SELECT * FROM T_MyISAM WHERE id BETWEEN x AND y;
COMMIT;