Berkeley CSUA MOTD:Entry 13107
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2024/11/23 [General] UID:1000 Activity:popular
11/23   

2004/4/9 [Computer/SW/Database] UID:13107 Activity:nil
4/8     In SQL, say I have two tables, one references to another. What is the
        query that will list all the entries in the first table that doesn't
        occur in the second table? I'd like to do "SELECT a.id FROM
        a,b WHERE a.id!=b.id". However, this doesn't quite work. Thanks.
        \_ The following works in PostgreSQL; I don't know if the IS NULL
           syntax is part of SQL or an extension. Note that, in Postgres,
           replacing 'IS NULL' with '= NULL' doesn't work.
           SELECT a.id FROM a LEFT OUTER JOIN b ON a.id=b.id WHERE b.id IS NULL
           There may well be a more efficient way of doing this, but this
           one works. -gm
        \_ SELECT id FROM first_table a WHERE NOT EXISTS
           (SELECT * FROM second_table b WHERE b.id = a.id)
2024/11/23 [General] UID:1000 Activity:popular
11/23   

You may also be interested in these entries...
2013/4/9-5/18 [Computer/SW/Languages/C_Cplusplus, Computer/SW/Apps, Computer/SW/Languages/Perl] UID:54650 Activity:nil
4/04    Is there a good way to diff 2 files that consist of columns of
        floating point numbers, such that it only tells me if there's a
        difference if the numbers on a given line differ by at least a given
        ratio?  Say, 1%?
        \_ Use Excel.
           1. Open foo.txt in Excel.  It should convert all numbers to cells in
	...
2010/1/22-30 [Computer/HW/Laptop, Computer/SW/OS/OsX] UID:53655 Activity:high
1/22    looking to buy a new development laptop
        needs ssdrive, >6 hr possible batt life, and runs linux reasonably
        Anyone have a recommendation? Thx.
        \_ thinkpad t23 w ssdrive and battery inplace of drive bay
        \_ Ever wondered what RICHARD STALLMAN uses for a laptop?  Well,
           wonder no more!
	...
2009/7/28-8/6 [Computer/SW/Database] UID:53213 Activity:nil
7/27    I have an actual technical question here. My MySQL DBA tells me
        that I can't expect a MySQL port to be able to run effectively
        on more than a two CPU box, he says that the extra CPUs will
        sit there unused. Is this true? I have a bunch of new quad core
        servers that I would like to use as Database machines. -ausman
   \_ It's not that simple.  If you stress test your new fancy multi core
	...
2009/2/27-3/5 [Computer/Networking] UID:52658 Activity:nil
2/27    I need to buy a wireless router, can u guys help me out?   I need the
        following features:  wireless, G or better, PPTP dial up, PPoE dialup,
        VoIP/SIP register, DDNS, uPnP.
        I am having a such hard time to find a review site which allow me to
        select these features.   Any ideas?  There are a couple model from
        this small company Draytek has these features, I am having the hardest
	...