查看指定库所有存储引擎
select table_schema,table_name,`engine` from information_schema.tables
WHERE TABLE_SCHEMA RLIKE 'db_name'
修改
SELECT CONCAT( 'ALTER TABLE ', TABLE_NAME, ' ENGINE=InnoDB;' )
FROM information_schema.tables
WHERE table_schema = 'db_name'