1.添加字段
alter table student add sex char(4) comment '性别' after name;
2.修改字段为 not null
alter table student modify sex char(4) not null;
3.change
alter table student change sex sex char(4) not null;
删除字段
alter table student drop ip;
1.添加字段
alter table student add sex char(4) comment '性别' after name;
alter table student modify sex char(4) not null;
alter table student change sex sex char(4) not null;
删除字段
alter table student drop ip;