MySQL批量修改表的编码和字符集
SELECT CONCAT("ALTER TABLE `", TABLE_NAME,"` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;") AS target_tables
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA="数据库名"
AND TABLE_TYPE="BASE TABLE"
复制上面的SQL,把数据库名改为自己的数据库名称,执行后的结果集就是修改编码和字符集的..
原创
2021-03-23 21:02:49 ·
219 阅读 ·
0 评论