數(shù)據(jù)庫： 引擎: InnoDB MyISAM MEMORY 執(zhí)行

select CONCAT('alter table ',table_name,' engine=InnoDB;') FROM information_schema.tables WHERE table_schema="數(shù)據(jù)庫名" AND ENGINE="InnoDB";