IF EXISTS for column names

[antun]

I know that with mySQL you can do:

DROP TABLE IF EXISTS tableName

However I want to do this for a column:

ALTER TABLE `tblName` DROP column IF EXISTS `importToSalesforce` ;

... which returns a SQL syntax error.

Is this not possible at all?

Thanks,

Antun

[rachel2004]

Dropping a column falls under the syntax of ALTER TABLE.

A quick check of the MySQL manual for the keywords "alter table" shows that yes, you can do a DROP COLUMN, but there is no clause for IF EXISTS in doing so.

http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html

By the way, you would be better served to post a question purely about MySQL to a list or forum that deals with MySQL. You question did not involve PHP in the way it was worded.