题解 | #修改表#

1. alter table [table_name] add column [column_name] after [column_name1];
2. 考察 对add , modify, change 三个关键字段的运用

alter table user_info add column school varchar(15) after level;
alter table user_info change job profession varchar(10);
alter table user_info modify achievement int(11) default 0 ;