题解 | #创建一张新表#

create table user_info_vip  like user_info;
alter table user_info_vip  DROP COLUMN achievement;
alter table  user_info_vip  add  achievement int (11) default 0 comment'成就值' after nick_name;
alter table user_info_vip drop column register_time;
alter table user_info_vip add register_time datetime  default current_timestamp comment '注册时间';