Hi Aaron,
that would need to be accomplished in 3 several steps I believe.
1) Add the prurple option with an ALTER command
2) REPLACE Blue with purple
3) ALTER the enum type again (remove blue option)
While I dont understand the meaning/background on this it might be a good idea
to keep the va
So I've got fairly big sized table (20,000 records) which has an ENUM
row. I need to change the name of one of the ENUM options. For
example, if the ENUM value was 'blue' before, it needs to be 'purple'
now. What's the best way to do this?
Thanks,
-Aaron
---
Aaron Blew
Jackson Cou
