mysql修改表的编码与修改表字段编码

修改表的编码

alter table tablename convert to character SET utf8mb4 COLLATE utf8mb4_unicode_ci;

修改表字段编码

ALTER TABLE tablename CHANGE fieldname fieldname VARCHAR(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;