ALTER TABLE, enum
Posted on 2004-08-03
I would like to change the contents of an enum field in my mysql table.
field1 enum('aaa','ccc','eee') default 'aaa'
field1 enum('aaa','bbb','ccc','eee') default 'aaa'
The table I am working with however is fully populated with data, and I'm worried that changing the enum field might corrupt the data in that field by changing the indicie values or something similar.
1) Does anyone know if changing the enum field (by just adding a new entry within it) will in any way corrupt the existing data?
2) What is the best method of updating the enum field to maintain the data? Would the following be sufficient and safe:
ALTER table1 modify field1 enum('aaa','bbb','ccc','eee') default 'aaa';
Please only answer if you are absolutely sure through experience or have a reference link to support your answer. I can't go on confident assumptions for this one. Hence my need to ask an expert. Thanks.