生成修改的语句
SELECT CONCAT('ALTER TABLE ',table_name,' ENGINE=InnoDB;') FROM information_schema.tables
WHERE table_schema='ambari' AND ENGINE='MyISAM';
本文转自 yntmdr 51CTO博客，原文链接：http://blog.51cto.com/yntmdr/1876529，如需转载请自行联系原作者
生成修改的语句
SELECT CONCAT('ALTER TABLE ',table_name,' ENGINE=InnoDB;') FROM information_schema.tables
WHERE table_schema='ambari' AND ENGINE='MyISAM';
