用ALTER TABLE 语句修改表结构

1.增加列

alter table tb_name add (column) col_name type;

2.删除列

alter table tb_name drop (column) col_name;

3.改变列的类型

alter table tb_name modify (column) col_name type;

4.重新定义列

alter table tb_name change (column) col_name col_name2 type;

5.给列改名

alter table tb_name change (column) col_name col_name2;

6.给表改名

alter table tb_name rename tb_name2;

for etc...