Add a new value in an ENUM by manipulate .frm

Hi, I need to add another value in an enum so ALTER TABLE table1 MODIFY Status ENUM('a','b','c') where 'c' is the new value. My problem is that the tables are VERY big and it would take days to alter them all. So, i figure the values in enum:s are in the .frm file so why not change it and

Re: Add a new value in an ENUM by manipulate .frm

Jörgen Winqvist schrieb: Hi, I need to add another value in an enum so ALTER TABLE table1 MODIFY Status ENUM('a','b','c') where 'c' is the new value. My problem is that the tables are VERY big and it would take days to alter them all. Tried it? I also use big tables but adding a field

Re: Add a new value in an ENUM by manipulate .frm

Barry wrote: Jörgen Winqvist schrieb: Hi, I need to add another value in an enum so ALTER TABLE table1 MODIFY Status ENUM('a','b','c') where 'c' is the new value. My problem is that the tables are VERY big and it would take days to alter them all. Tried it? I also use big tables but