题解 | #创建一张新表#
创建一张新表
http://www.nowcoder.com/practice/a61ee5519d14444aa99e530309a8e043
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;
#对于非空约束也要写好
