Drop multiple column in MYSQL
by Rekha[ Edit ] 2010-03-23 11:24:33
Mysql allows you to drop multiple columns in a table.
Syntax:
Alter table table_name drop column column1,drop column column2,drop column column3............
Ex:
alter table test drop column name,drop column address
