Berkeley CSUA MOTD:Entry 33839
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2025/04/04 [General] UID:1000 Activity:popular
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
2025/04/04 [General] UID:1000 Activity:popular
4/4     

You may also be interested in these entries...
2010/12/11-2011/2/19 [Computer/SW/Languages/Perl] UID:53984 Activity:nil
12/11   Anyone have experience with Perl PDF::API2 or PDF::API3?  Can you
        point me to a good tutorial for creating a simple document (a small
        table of 2-3 rows and a single image)?
	...
2010/7/21-8/9 [Computer/SW/OS/FreeBSD] UID:53890 Activity:nil
7/21    Can I just use ifconfig to expand my netmask on a FreeBSD box?
        Are there any gotchas here? Linux forces me to restart my network
        to expand my netmask.
        \_ yes... and no, you don't have to restart your network on linux either
           \_ Rebooting is the Ubootntoo way!
              \_ Oooboot'n'tootin!
	...