MySQL一次性添加/删除多个字段

ALTER TABLE table_name
ADD COLUMN AddParam1 VARCHAR(255),
ADD COLUMN AddParam2 VARCHAR(255),
ADD COLUMN AddParam3 VARCHAR(255),
ADD COLUMN AddParam4 VARCHAR(255)

ALTER TABLE table_name 
DROP AddParam1,
DROP AddParam2,
DROP AddParam3,
DROP AddParam4,
DROP AddParam5

 

posted on 2017-03-22 11:01  Li Kui  阅读(1418)  评论(1)    收藏  举报