Bug #8252 Cannot add a new enum value to a table column
Submitted: 2 Feb 2005 3:50 Modified: 2 Feb 2005 5:30
Reporter: Hector Macias Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.5 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[2 Feb 2005 3:50] Hector Macias 
Description:
Adding a new enum value to an already existent column and then applying the changes generates an 1064 error.

How to repeat:
Create a table with a column with enum values. Then try to add a new enim value to that column.
[2 Feb 2005 5:30] Aleksey Kishkin 
tested on winxp sp 2, query browser 1.1.5 on mysql 4.1.9-nt. When query browser creates sql query 'alter table', default value for enum field is without quotes, (this leads to syntax error). So it looks like duplicate of http://bugs.mysql.com/bug.php?id=7934
[24 Aug 2006 6:42] Amit Nanote 
hi Friend Please find the following solution for Your problem. 

Create a table 
add enum data type column to it
Now modify the column. 

This will easily modify the column of the table. If the respective column is having value then also it wont create problem provided the set must have the previously set value.

alter table  tt add tt12 ENUM ("YES","NO");

/* Result : "Query OK, 1 rows affected (0.00 sec)" */

alter table  tt modify tt12 ENUM ("YES","NO","CANT SAY");

/* Result : "Query OK, 1 rows affected (0.00 sec)" */