SELECT GROUP_CONCAT(CONCAT('ALTER TABLE `',`TABLE_SCHEMA`,'`.`',`TABLE_NAME`,"` ENGINE=innoDB;") SEPARATOR ' ')
INTO @altersql
FROM `information_schema`.`tables`
WHERE
`TABLE_SCHEMA` = 'test'
AND `ENGINE` = 'MyISAM';
SELECT @altersql;
PREPARE stmt FROM @altersql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;