RE: Multiple items in an ALTER TABLE statement

2 PM > To: MySQL List > Subject: Multiple items in an ALTER TABLE statement > > > Was in the midst of doing something today and I attempted to drop a > number of columns in a table with the following: > > ALTER TABLE tmp DROP COLUMN col_1, col_2, col_3, col_4; > &g

Re: Multiple items in an ALTER TABLE statement

states that: You can issue multiple ADD, ALTER, DROP, and CHANGE clauses in a single ALTER TABLE statement. This is a MySQL extension to SQL-92, which allows only one of each clause per ALTER TABLE statement. but it doesn't give the syntax for doin

Multiple items in an ALTER TABLE statement

Was in the midst of doing something today and I attempted to drop a number of columns in a table with the following: ALTER TABLE tmp DROP COLUMN col_1, col_2, col_3, col_4; Unfortunately MySQL gave me an error reading: ERROR 1064: You have an error in your SQL syntax. Check the manual that co