1、更改表(school)的字符集
alter table school charset=utf8mb4 collate=utf8mb4_general_ci;
2、更改表(school)字段(schoolName)的字符集
ALTER TABLE school modify column SchoolName varchar(50) CHARACTER SET utf8mb4 COLLATE set utf8mb4_general_ci;
1、更改表(school)的字符集
alter table school charset=utf8mb4 collate=utf8mb4_general_ci;
2、更改表(school)字段(schoolName)的字符集
ALTER TABLE school modify column SchoolName varchar(50) CHARACTER SET utf8mb4 COLLATE set utf8mb4_general_ci;