RE: Multiple items in an ALTER TABLE statement

ALTER TABLE tmp DROP COLUMN col_1, DROP COLUMN col_2, DROP COLUMN col_3, DROP COLUMN col_4; Or, for short, ALTER TABLE tmp DROP col_1, DROP col_2, DROP col_3, DROP col_4; > -Original Message- > From: Adam Fortuno [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 12, 2003 6:22 PM > To: My

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