//刪除表的多個(gè)字段

ALTER? TABLE? table_name

DROP? COLUMN ? field_name1,

DROP? COLUMN ? field_name2,

...

//新增表的多個(gè)字段

ALTER TABLE ?table_name

ADD ?COLUMN ?field_name1 ?tinyint(2) ?NOT ?NULL ? COMMENT ?' ',

ADD COLUMN ?field_name2 ?int(10) ?NOT NULL ?COMMENT ?' ',

...

//修改表的字段

ALTER TABLE table_name

MODIFY? COLUMN?? field_name1? tinyint(2)? NOT? NULL? COMMENT? ' ',

MODIFY COLUMN? field_name2 int(10)? NOT NULL? COMMENT? ' ',

...