mysql 批量修改表及字段字符集
-- 修改表字符集
SELECT CONCAT('ALTER TABLE `', TABLE_NAME,'` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;')
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA='test'
AND TABLE_TYPE='BASE ...
转载
2019-11-18 15:20:11 ·
1000 阅读 ·
2 评论
关注
分享
扫一扫