SET @DATABASE_NAME = name_of_your_db;SELECT CONCAT(ALTER TABLE `, table_name, ` ENGINE=InnoDB;) AS sql_statementsFROM information_schema.tables AS tbWHERE table_schema = @DATABASE_NAMEAND `ENGINE` = MyISAMAND `TABLE_TYPE` = BASE TABLEORDER BY table_name DESC;