题解 | #创建一张新表#

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

#对于非空约束也要写好