|
|
Add/Delete multiple columns in a single alter statement - Mysql
|
Views : 835
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
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 |
|
|
|
