SET @DATABASE_NAME = 't_kp_2';
SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE=MyISAM;') AS sql_statements
FROM information_schema.tables AS tb
WHERE table_schema = @DATABASE_NAME
AND `ENGINE` = 'InnoDB'
AND `TABLE_TYPE` = 'BASE TABLE';
commit;
mysql 批量修改数据库表 默认存储引擎
最新推荐文章于 2023-02-19 23:24:22 发布