DDL语句实现插入字段以及字符编码
ALTER TABLE 表名 ADD 字段名 字段类型 CHARACTER
SET 字符集 COLLATE 排序规则 DEFAULT NULL COMMENT '备注' AFTER 跟在哪个字段后面;
eg:ALTER TABLE kehu ADD new_customer_phone VARCHAR (255) CHARACTER
SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户手机号' AFTER customer_phone;