| ||||||
| 5/20 |
| 2004/9/29-30 [Computer/SW/Languages/Misc] UID:33839 Activity:nil |
9/29 MySQL question: If I create a table where one column is an ENUM such
as ENUM('a','b','c') can I later expand the enumerated values to say
add 'd' to the possibilities, or do I have to rebuild the whole table?
\_ Not really (although I think this makes MySQL silently rebuilt
the table anyway):
ALTER TABLE foo CHANGE bar bar ENUM ('a','b','c','d');
-geordan
\_ Slightly shorter:
ALTER TABLE foo MODIFY bar ENUM ('a','b','c','d');
--dbushong |
| 5/20 |
|