```
反引号可以屏蔽关键字问题(如:where,limit,order)
修改数据表字段:
alter table tablename add sex tinyint not null;
alter table tablename add sex tinyint not null after name;
alter table tablename add sex tinyint not null first;
删除:
alter table tablename drop sex;
改:
alter table tablename change name username varchar(30) not null;
alter table tablename modify username varchar(50) not null;
```
> ***注意,change是改变列名,modify是改变数据类型***