本文介绍了一种从MyISAM表引擎转换为InnoDB表引擎的方法，通过查询当前使用MyISAM引擎的表并生成对应的ALTER TABLE SQL语句来实现转换。
#查询表引擎
SELECT CONCAT(table_name,'
FROM information_schema.tables WHERE table_schema="henryDB" AND ENGINE="MyISAM";
#生成修改sql
SELECT CONCAT('ALTER TABLE ',table_name,' ENGINE=InnoDB;') FROM information_schema.tables
WHERE table_schema="henryDB" AND ENGINE="MyISAM";
结果：
ALTER TABLE t_config ENGINE=InnoDB;
ALTER TABLE t_dic ENGINE=InnoDB;
ALTER TABLE t_files ENGINE=InnoDB;
SELECT CONCAT(table_name,'
FROM information_schema.tables WHERE table_schema="henryDB" AND ENGINE="MyISAM";
#生成修改sql
SELECT CONCAT('ALTER TABLE ',table_name,' ENGINE=InnoDB;') FROM information_schema.tables
WHERE table_schema="henryDB" AND ENGINE="MyISAM";
结果：
ALTER TABLE t_config ENGINE=InnoDB;
ALTER TABLE t_dic ENGINE=InnoDB;
ALTER TABLE t_files ENGINE=InnoDB;
扫一扫
1345
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
