mysql4

Using ALTER to drop a column if it exists in MySQL

For MySQL, there is none: MySQL Feature Request. Allowing this is arguably a really bad idea, anyway: IF EXISTS indicates that you’re running destructive operations on a database with (to you) unknown structure. There may be situations where this is acceptable for quick-and-dirty local work, but if you’re tempted to run such a statement against … Read more