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';