mysql 批量修改表字符集与字段字符集方法

以下以“utf8_general_ci”转“utf8mb4_general_ci”为例：

 

一、mysql批量修复表编码；

ALTER DATABASE db_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci;

二、mysql批量修改字段字段编码：
 

ALTER TABLE `table_1` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE `table_2` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE `table_3` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE `table_4` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE `table_5` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;