How do I add more members to my ENUM-type column in MySQL?

by 
ALTER TABLE
    `table_name`
MODIFY COLUMN
    `column_name2` enum(
        'existing_value1',
        'existing_value2',
        'new_value1',
        'new_value2'
    )
NOT NULL AFTER `column_name1`;

More Related Contents:

  1. add column to mysql table if it does not exist
  2. MySQL: ALTER TABLE if column not exists
  3. Adding multiple columns AFTER a specific column in MySQL
  4. How can I modify the size of column in a MySQL table?
  5. MySQL ENUM type vs join tables
  6. Error renaming a column in MySQL
  7. ALTER TABLE to add a composite primary key
  8. How to add not null constraint to existing column in MySQL
  9. Alter MySQL table to add comments on columns
  10. MySQL Enum performance advantage?
  11. Create an index on a huge MySQL production table without table locking
  12. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  13. ALTER table – adding AUTOINCREMENT in MySQL
  14. How to change MySQL column definition?
  15. Alter table if exists or create if doesn’t
  16. `MODIFY COLUMN` vs `CHANGE COLUMN`
  17. Optimizing MySQL for ALTER TABLE of InnoDB
  18. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)
  19. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  20. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  21. How to use LOAD_FILE to load a file into a MySQL blob?
  22. Determine Rank based on Multiple Columns in MySQL
  23. What is better in MYSQL count(*) or count(1)?
  24. How do I repair an InnoDB table?
  25. How to enable INNODB in mysql
  26. How do I lag columns in MySQL?
  27. Calculate distance given 2 points, latitude and longitude [duplicate]
  28. How to write a (MySQL) “LIMIT” in SQL Server?
  29. SQL: deleting tables with prefix
  30. How to use a user variables in MySQL LIKE clause?

Leave a Comment