题解 | #创建一张新表#
创建一张新表
https://www.nowcoder.com/practice/a61ee5519d14444aa99e530309a8e043
drop table if EXISTS user_info_vip; CREATE TABLE IF NOT EXISTS user_info_vip ( id int 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 '注册时间' )CHARACTER SET utf8 COLLATE utf8_general_ci;


查看25道真题和解析