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

Question

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.

Smar · Accepted Answer · 2015-10-26 13:08:43Z

50

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.

edited Oct 26, 2015 at 13:08

Smar

8,6723 gold badges38 silver badges49 bronze badges

answered Apr 6, 2012 at 17:53

Asaph

163k25 gold badges204 silver badges204 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alex Over a year ago

how to set default value in this statement. SET DEFAULT 'a' doesn't work for me.

Muhammad Shahzad · Accepted Answer · 2016-07-19 05:40:59Z

-3

If you want to add default value and also want after a specific column for enum, try this query:

Alter table `your_table` 
Add column `visible_on` enum('web','mobile','both') default 'both' 
After `your_column`;

answered Jul 19, 2016 at 5:40

Muhammad Shahzad

9,68022 gold badges90 silver badges130 bronze badges

2 Comments

Chris Kraszewski Over a year ago

How is this related to the question?

Toby Speight Over a year ago

Thank you for this code snippet, which might provide some limited short-term help. A proper explanation would greatly improve its long-term value by showing why this is a good solution to the problem, and would make it more useful to future readers with other, similar questions. Please edit your answer to add some explanation, including the assumptions you've made.

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related