1、用sql生成批量改字段排序规则的sql
#utf8mb4是原排序规则,utf8mb4_0900_ai_ci是要修改成的排序规则
SELECT CONCAT('ALTER TABLE ',table_name,' MODIFY ',column_name,' ',data_type,'(',character_maximum_length,') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;') FROM information_schema.COLUMNS WHERE table_name = '这里填表名';
2、然后复制执行生成的sql即可