Re: alter table change enum set

What if I have the following: enum('foo','bar','baz') default 'bar' not null. What if I want to change the value of "bar" to "bee"? What is the best way to implement this in mysql? What if I want to change the default value? Nicole Sweeney Software Configuration Engineer Akamai Technologies

Re: alter table change enum set

I have a similar mysql enum question. What if I have the following: enum('foo','bar','baz') default 'bar' not null. What if I want to change the value of "bar" to "bee"? What is the best way to implement this? Nicole Sweeney Software Configuration Engineer Akamai Technologies 858-909-3654 work 8