Add/Delete multiple columns in a single alter statement - Mysql Views : 835
Tagged in : Mysql
1 0
Send mail
Add / Delete Multiple columns in a single statement

You can use multiple ADD, DROP clauses in a single ALTER statement, separated by commas.

Add multiple columns in a single alter statement

    ALTER TABLE t2 ADD COLUMN c, ADD COLUMN d;


Delete multiple columns in a single alter statement

    ALTER TABLE t2 DROP COLUMN c, DROP COLUMN d;

By Ramya, On - 2008-11-11



    Login to add Comments .