增加一列
Alter table TABLENAME add COLUMNNAME COLUMNTYPE IFNULL
EX:
Alter table myTable add myDate datetime null
删除一列
Alter table TABLENAME drop COLUMNNAME
EX:
Alter table myTable drop myDate
增加一列
Alter table TABLENAME add COLUMNNAME COLUMNTYPE IFNULL
EX:
Alter table myTable add myDate datetime null
删除一列
Alter table TABLENAME drop COLUMNNAME
EX:
Alter table myTable drop myDate