MySQL 批量 转换 数据库引擎

共计 500 个字符，预计需要花费 2 分钟才能阅读完成。

InnoBD 转 MyISAM

SET @DATABASE_NAME = '数据库名称';
SELECT  CONCAT('ALTER TABLE `', table_name, '` ENGINE=MyISAM;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = @DATABASE_NAME
AND     `ENGINE` = 'InnoDB'
AND     `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;

MyISAM 转 InnoBD

SET @DATABASE_NAME = '数据库名称';
SELECT  CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = @DATABASE_NAME
AND     `ENGINE` = 'MyISAM'
AND     `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;

执行生成后的语句即可