ALTER TABLE user_info add column school varchar(15) after level, #在level后新增列 change column job profession varchar(10), #把job改为profession modify column achievement int(11)default 0; #修改默认值