追风之云

SELECT concat('alter table `’, TABLE_SCHEMA, ‘`.`’, TABLE_NAME, ‘` engine=innodb;')
FROM information_schema.TABLES
WHERE ENGINE='MyIASM' AND
TABLE_SCHEMA<>'mysql' AND
TABLE_SCHEMA<>'information_schema' AND
TABLE_SCHEMA='MYDB';



SELECT CONCAT( 'ALTER TABLE ' ,TABLE_NAME ,' ENGINE=InnoDB; ') as `sql-commands-for-convert-engine`
FROM information_schema.TABLES AS t
WHERE TABLE_SCHEMA = 'MYDB' AND TABLE_TYPE = 'BASE TABLE';