生成修改的语句
SELECT CONCAT('ALTER TABLE ',table_name,' ENGINE=InnoDB;') FROM information_schema.tables
WHERE table_schema='ambari' AND ENGINE='MyISAM';
生成修改的语句
SELECT CONCAT('ALTER TABLE ',table_name,' ENGINE=InnoDB;') FROM information_schema.tables
WHERE table_schema='ambari' AND ENGINE='MyISAM';
转载于:https://www.cnblogs.com/zangao/p/6101929.html