您好,欢迎来到叨叨游戏网。
搜索
您的当前位置:首页myisam表转换为innodb表_MySQL

myisam表转换为innodb表_MySQL

来源:叨叨游戏网


从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

Copyright © 2019- gamedaodao.net 版权所有 湘ICP备2024080961号-6

违法及侵权请联系:TEL:199 18 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务