Jeetendra Pujari Jeetendra Pujari - 4 months ago 13
SQL Question

Mysql Add a new value to a column of data type enum

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
.

Answer

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.

Comments