|
4/4 |
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 |
4/4 |
|