mysql批量把MyISAM转成InnoDB引擎语句

SELECT CONCAT('ALTER TABLE ', table_schema, '.', table_name, ' ENGINE=InnoDB;')
FROM information_schema.tables
WHERE table_schema = '表名'
  AND engine = 'MyISAM';

  

posted @ 2025-03-22 19:33  圆柱模板  阅读(15)  评论(0)    收藏  举报