Is it possible and safe to add an ENUM value to an SQL database column type?

Question

I have an application that works with a database (PHP + MySQL).

One of the columns in the database table is of type ENUM('VALUE1','VALUE2').

Is it safe to add VALUE3in ENUMwithout damaging the data in the table?

Answer 1

if added to the end, it seems safe, see manual

"" ALTER , :     ....      ENUM SET . ( , .)

:

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

:

http://www.brandonsavage.net/why-you-should-replace-enum-with-something-else/