mysql学习笔记

修改table名字

 alter table teacher rename teachers;

修改字段属性

 alter table teacher modify id tinyint not null;

添加一个列

alter table teacher add time timestamp not null;

删除一个列

alter table teacher drop column timestamp;