SELECT CONCAT('USE ', table_schema, '; ALTER TABLE ', table_name, ' ENGINE=InnoDB;')
FROM information_schema.tables
WHERE engine = 'MyISAM'
AND table_schema NOT IN ('mysql', 'information_schema', 'performance_schema');
生成所有的ALTERs,将所有MyISAM表转换为InnoDB
最新推荐文章于 2024-06-18 10:30:00 发布