MySQL之变更操作

作者：Odboy (opens new window)

本站地址：https://blog.odboy.cn (opens new window)

改变表字符集

# 字符集为 utf8mb4_general_ci
ALTER TABLE my_table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

# 字符集为 utf8mb4_0900_ai_ci
ALTER TABLE my_table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;