题解 | #创建一张新表#

建表的语句 ： character set utf8 COLLATE utf8_general_ci ,建表之时给字段添加注释  comment '昵称';

drop table if exists user_info_vip ; 
create table user_info_vip (
   id int(11) not null primary key auto_increment  comment  '自增ID',
   uid int(11) not null unique comment '用户ID',
   nick_name varchar(64)  CHARACTER SET utf8 COLLATE utf8_general_ci comment '昵称',
   achievement int(11) default 0 comment '成就值',
   level int(11) comment '用户等级',
   job varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci comment '职业方向',
   register_time datetime default CURRENT_TIMESTAMP comment '注册时间'
)CHARACTER SET utf8 COLLATE utf8_general_ci;