View Full Version : can one change enum w/o losing content?

06-04-2007, 07:07 AM
In MySQL 4.1.21-standard - suppose you had an enum column like this:

CREATE TABLE sizes (name ENUM('1', '2', '3'));

Next suppose you have that table populated with a hundred names when suddenly you want to add the value '4' to the list of options.

Is there a way to modify the enum (add or delete) options without losing data?