MySQL: ALTER TABLE if column not exists

by

Use the following in a stored procedure:

IF NOT EXISTS( SELECT NULL
            FROM INFORMATION_SCHEMA.COLUMNS
           WHERE table_name="tablename"
             AND table_schema="db_name"
             AND column_name="columnname")  THEN

  ALTER TABLE `TableName` ADD `ColumnName` int(1) NOT NULL default '0';

END IF;

More Related Contents:

  1. add column to mysql table if it does not exist
  2. Adding multiple columns AFTER a specific column in MySQL
  3. Can a number be used to name a MySQL table column?
  4. How can I modify the size of column in a MySQL table?
  5. Error renaming a column in MySQL
  6. ALTER TABLE to add a composite primary key
  7. How to add not null constraint to existing column in MySQL
  8. Alter MySQL table to add comments on columns
  9. Using ALTER to drop a column if it exists in MySQL
  10. Create an index on a huge MySQL production table without table locking
  11. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  12. ALTER table – adding AUTOINCREMENT in MySQL
  13. How to change MySQL column definition?
  14. Alter table if exists or create if doesn’t
  15. `MODIFY COLUMN` vs `CHANGE COLUMN`
  16. How do I add more members to my ENUM-type column in MySQL?
  17. ALTER TABLE without locking the table?
  18. Optimizing MySQL for ALTER TABLE of InnoDB
  19. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)
  20. How to use GROUP_CONCAT in a CONCAT in MySQL
  21. MySQL query / clause execution order
  22. How can I tell when a MySQL table was last updated?
  23. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  24. Are nested transactions allowed in MySQL?
  25. MyIsam engine transaction support
  26. SQL Query to get column values that correspond with MAX value of another column?
  27. MySQL : transaction within a stored procedure
  28. Implementing a hierarchical data structure in a database
  29. How to get current date & time in MySQL?
  30. How do I split the output from mysqldump into smaller files?

Leave a Comment