mysql批量把MyISAM转成InnoDB引擎语句
SELECT CONCAT('ALTER TABLE ', table_schema, '.', table_name, ' ENGINE=InnoDB;') FROM information_schema.tables WHERE table_schema = '表名' AND engine = 'MyISAM';
千行代码,Bug何处藏。 纵使上线又怎样,朝令改,夕断肠。
SELECT CONCAT('ALTER TABLE ', table_schema, '.', table_name, ' ENGINE=InnoDB;') FROM information_schema.tables WHERE table_schema = '表名' AND engine = 'MyISAM';