Mysql Add a new value to a column of data type enum
ddl, mysql
Solution
Unfortunately, you need to re-list all the existing enum values when adding a new value to the the enum.
ALTER TABLE mytable MODIFY COLUMN mycolumn ENUM('a','b','c','d','e');
You don't really want to use `CONCAT()` in this situation.
Problem
Say I have a mysql table, and I have a column of type `enum` and that column has defined set of values like `enum('a','b','c','d')`. How would i add a value of `'e'` to this set using alter table statement? And I want to append the new value to the end of it using `CONCAT`.