1.Mysql获取非事务引擎的命令
SELECT table_schema database_name,table_name,engine FROM information_schema.tables WHERE table_schema NOT IN ('mysql','information_schema','performance_schema','sys') AND engine <> 'InnoDB';
2.获取修改存储引擎的脚本（执行表中的语句即可修改非事务引擎）
SELECT CONCAT('ALTER TABLE',table_schema,'.',table_name,'ENGINE=InnoDB;') sql_text FROM information_schema.TABLES WHERE table_schema NOT IN ('mysql','information_schema','performance_schema','sys')AND engine <> 'InnoDB';
3.执行语句修改
