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

mysql ddl
Jeetendra Pujari picture Jeetendra Pujari · Apr 6, 2012 · Viewed 29.7k times · Source

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

Asaph picture Asaph · Apr 6, 2012

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.

Related questions

How to delete a column from a table in MySQL

Given the table created using: CREATE TABLE tbl_Country ( CountryId INT NOT NULL AUTO_INCREMENT, IsDeleted bit, PRIMARY KEY (CountryId) ) How can I delete the column IsDeleted?

Read More
Adding multiple columns AFTER a specific column in MySQL

I need to add multiple columns to a table but position the columns after a column called lastname. I have tried this: ALTER TABLE `users` ADD COLUMN ( `count` smallint(6) NOT NULL, `log` varchar(12) NOT NULL, `status` int(10) unsigned NOT NULL ) …

Read More
There can be only one auto column

How do I correct the error from MySQL 'you can only have one auto increment column'. CREATE TABLE book ( id INT AUTO_INCREMENT NOT NULL, accepted_terms BIT(1) NOT NULL, accepted_privacy BIT(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Read More