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

2021-02-1317学堂2发消息

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

转载于:https://www.cnblogs.com/kuili/p/6598757.html

技术多个字段