Berkeley CSUA MOTD:Entry 33585
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2025/05/24 [General] UID:1000 Activity:popular
5/24    

2004/9/17 [Computer/SW/Database, Computer/SW/Languages/Misc] UID:33585 Activity:nil
9/17    In SQL it seems DATE, DATETIME, TIME and TIMESTAMP are all reserved
        words.  What do you use to name your date fields?
        \_ What date it actually is, e.g.: "created_date", "updated_date",
           "renewed_date" (or just "created", "updated", "renewed", etc)
           --dbushong
           \_ Good idea, thanks.  Another question:  How do I create a table
              with a record which is an array of strings, eg: a table of
              some type of record where one element is a list of keywords.
              Do I have to put all the keywords in one string and do something
              like comma-seperation?
              \_ If they're going to be of varying length and short, then the
                 comma separation bit will work.  Otherwise, make a new keyword
                 table and tie it to the first table with a foreign key.
2025/05/24 [General] UID:1000 Activity:popular
5/24    

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!
	...