Categories

Drop multiple column in MYSQL

Views:847

Belongs to : Mysql

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



By - Rekha, On - 2010-03-23

User Comments

Add NEW Feedback: