Home >Database >Mysql Tutorial >myisam 表 转换为 innodb 表_MySQL
myisam 表 转换为 innodb 表_MySQL
- WBOYOriginal
- 2016-06-01 13:06:07935browse
从InnoDB引擎转换成MyISAM引擎，看完本文，你应该懂得如何操作以把MyISAM引擎转换成InnoDB引擎了（请确保InnoDB开启，MySQL命令行下SHOW ENGINES命令查看）。
mysql> ALTER TABLE boblog_history ENGINE=InnoDB;
Query OK, 2808 rows affected (0.76 sec)
Records: 2808 Duplicates: 0 Warnings: 0
ALTER TABLE boblog_blogs ENGINE=InnoDB;
ALTER TABLE boblog_calendar ENGINE=InnoDB;
ALTER TABLE boblog_categoriesENGINE=InnoDB;
ALTER TABLE boblog_counter ENGINE=InnoDB;
ALTER TABLE boblog_forbidden ENGINE=InnoDB;
ALTER TABLE boblog_history ENGINE=InnoDB;
ALTER TABLE boblog_linkgroup ENGINE=InnoDB;
ALTER TABLE boblog_links ENGINE=InnoDB;
ALTER TABLE boblog_maxrec ENGINE=InnoDB;
ALTER TABLE boblog_messages ENGINE=InnoDB;
ALTER TABLE boblog_mods ENGINE=InnoDB;
ALTER TABLE boblog_pages ENGINE=InnoDB;
ALTER TABLE boblog_plugins ENGINE=InnoDB;
ALTER TABLE boblog_replies ENGINE=InnoDB;
ALTER TABLE boblog_tags ENGINE=InnoDB;
ALTER TABLE boblog_upload ENGINE=InnoDB;
ALTER TABLE boblog_user ENGINE=InnoDB;
来自：http://www.samhere.net/mysql_innodb_to_myisam.html