题解 | #删除记录（四）#

CREATE TABLE user_info_vip (     id INT (11) PRIMARY KEY auto_increment comment "自增ID",     uid INT (11) not null UNIQUE KEY 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


primary key--->主键
unique key--->唯一约束
not null--->非空
comment--->评论
default--->默认值
default current_timestamp--->默认为当前时间
default charset=utf8--->默认编码