Toad World® Forums

Bug: MySQL - Drop column syntax


#1

I’ve created a migration script for MySQL 5.0 database.

The generated statement was

ALTER TABLE MYTABLE DROP
COLUMN MY_COLUMN_ONE,
COLUMN MY_COLUMN_TWO
;

But this fails with a syntax error.

According to http://dev.mysql.com/doc/refman/5.0/en/alter-table.html the statement must be:

ALTER TABLE MYTABLE DROP
COLUMN MY_COLUMN_ONE,
DROP COLUMN MY_COLUMN_TWO
;

Is it possible to get a workaround?


#2

Hi,

Thanks for your notification. This issue is registered under CR 72 325.
Workaround - Please check out your private messages section for my message. Thanks.

Regards,

Vladka + TDM Team