Re: Add enum value to existing table?

[Peter Brawley]

drop table if exists t;
create table t(id int primary key, state enum('one','two') );
insert into t values(1,'one'),(2,'two');
alter table t modify state enum('one','two','three');
insert into t values(3,'three');