MySQL批量转换MyISAM引擎为InnoDB引擎

1、执行SQL，生成转换SQL语句

SELECT
	concat( 'alter table ', table_schema, '.', table_name, ' ENGINE=InnoDB; ' ) AS t 
FROM
	information_schema.TABLES 
WHERE
	table_type = 'BASE TABLE' 
	AND table_schema = 'database_name';

2、执行生成的SQL语句，修改数据表引擎