quint
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?
Thanks,
~q
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?
Thanks,
~q