修改mysql字符集与排序规则

修改数据库

ALTER DATABASE your_database_name 
CHARACTER SET = utf8mb4 
COLLATE = utf8mb4_general_ci;

修改表

ALTER TABLE your_table_name 
CONVERT TO CHARACTER SET utf8mb4 
COLLATE utf8mb4_general_ci;

修改字段

ALTER TABLE your_table_name 
CHANGE COLUMN your_column_name your_column_name VARCHAR(255) 
CHARACTER SET utf8mb4 
COLLATE utf8mb4_general_ci;