Using ALTER to drop a column if it exists in MySQL

by

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 production data (in a migration etc.), you’re playing with fire.

But if you insist, it’s not difficult to simply check for existence first in the client, or to catch the error.

MariaDB also supports the following starting with 10.0.2:

DROP [COLUMN] [IF EXISTS] col_name

i. e.

ALTER TABLE my_table DROP IF EXISTS my_column;

But it’s arguably a bad idea to rely on a non-standard feature supported by only one of several forks of MySQL.

More Related Contents:

  1. add column to mysql table if it does not exist
  2. Can a number be used to name a MySQL table column?
  3. MySQL: ALTER TABLE if column not exists
  4. Adding multiple columns AFTER a specific column in MySQL
  5. Summing a comma separated column in MySQL 4 (not 5)
  6. How to item balance
  7. How to delete duplicates on a MySQL table?
  8. need to return two sets of data with two different where clauses
  9. nodejs mysql Error: Connection lost The server closed the connection
  10. Best data type to store money values in MySQL
  11. How to fix “Incorrect string value” errors?
  12. MySQL: How to allow remote connection to mysql
  13. Order a MySQL table by two columns
  14. What’s the difference between ” = null” and ” IS NULL”?
  15. Querying multiple databases at once
  16. Sorting varchar field numerically in MySQL
  17. Setting up foreign keys in phpMyAdmin?
  18. How to get an age from a D.O.B field in MySQL?
  19. Invalid default value for ‘dateAdded’
  20. MySQL: When is Flush Privileges in MySQL really needed?
  21. MySQL too long varchar truncation/error setting
  22. MySQL: update a field only if condition is met
  23. How to get number of rows affected, while executing MySQL query from bash?
  24. What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL?
  25. Detecting locked tables (locked by LOCK TABLE)
  26. Access denied after setting user’s password with SHA256 in phpMyAdmin
  27. connecting MySQL server to NetBeans
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment