mysql怎样一次删除两个字段

[jifflin]

如题目所说，我想删掉一个表格中的两个以上的字段，请问应该怎么做呢
alter table jj column.............
后面应该怎么写啊？请高手指点下，谢谢。

[jifflin]

以上三种都不行啊，我试过了，是mysql下的
要一次删除两个字段以上，删除一个字段的话可以这样写：alter table table_name drop column_name;
但我想删除两个以上呢？mysql下怎么实现啊？

[zhoche2008]

不知道啊.没试过.去查他的文档吧.

[老紫竹]

从MYSQL的手册查到，可能得如下方法了
alter table tablename
drop column1, drop column2,drop column3


[code=INIFile]ALTER [IGNORE] TABLE tbl_name
alter_specification [, alter_specification] ...

alter_specification:
table_option ...
| ADD [COLUMN] column_definition [FIRST | AFTER col_name ]
| ADD [COLUMN] (column_definition,...)
| ADD {INDEX|KEY} [index_name] [index_type] (index_col_name,...)
| ADD [CONSTRAINT [symbol]]
PRIMARY KEY [index_type] (index_col_name,...)
| ADD [CONSTRAINT [symbol]]
UNIQUE [INDEX|KEY] [index_name] [index_type] (index_col_name,...)
| ADD [FULLTEXT|SPATIAL] [INDEX|KEY] [index_name] (index_col_name,...)
| ADD [CONSTRAINT [symbol]]
FOREIGN KEY [index_name] (index_col_name,...)
[reference_definition]
| ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}
| CHANGE [COLUMN] old_col_name column_definition
[FIRST|AFTER col_name]
| MODIFY [COLUMN] column_definition [FIRST | AFTER col_name]
| DROP [COLUMN] col_name
| DROP PRIMARY KEY
| DROP {INDEX|KEY} index_name
| DROP FOREIGN KEY fk_symbol
| DISABLE KEYS
| ENABLE KEYS
| RENAME [TO] new_tbl_name
| ORDER BY col_name [, col_name] ...
| CONVERT TO CHARACTER SET charset_name [COLLATE collation_name]
| [DEFAULT] CHARACTER SET charset_name [COLLATE collation_name]
| DISCARD TABLESPACE
| IMPORT TABLESPACE

index_col_name:
col_name [(length)] [ASC | DESC]

index_type:
USING {BTREE | HASH}[/code]

[eidolon_warrior]

alter table table_name drop(column_name);

[dawnming]

alter table table_name drop(column_name);

[老紫竹]

alter       table       table_name  	DROP COLUMN 
column1, column2，column3

[shaojuntao]

楼上的说的正确,在MYSQL 5.0测试通过!
alter table tablename drop column1,drop column2