mysql如何用sql添加字段如何设置字符集和排序规则

alter table pay_company add sms_code2 varchar(16) CHARACTER SET UTF8 COLLATE utf8_general_ci DEFAULT null;