Berkeley CSUA MOTD:Entry 16852
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2025/04/04 [General] UID:1000 Activity:popular
4/4     

1999/11/9 [Computer/SW/Database] UID:16852 Activity:very high
11/8    Hello how do I use Select statement in mysql to find and display the
        most current pollID, given a table called vbooth_desc from mydb.
        Basically I want $newpoll to always be the greatest pollID #.

        I have tried defining variables with Select that don't work:
        $newpoll=mysql_query("SELECT max(pollID) FROM vbooth_desc") &
        $newpoll=mysql_query("SELECT * FROM vbooth_desc WHERE GREATEST(pollID)

        from mydb.vbooth_desc;

        +-----------+-----------+------+-----+---------+----------------+
        | Field     | Type      | Null | Key | Default | Extra          |
        +-----------+-----------+------+-----+---------+----------------+
        | pollID    | int(11)   |      | PRI | 0       | auto_increment |
        | pollTitle | char(100) |      |     |         |                |
        | timeStamp | int(11)   |      |     | 0       |                |
        +-----------+-----------+------+-----+---------+----------------+
        \_ "select pollID from vbooth_desc order by desc"  maybe... --peterl
        \_ "SELECT * FROM vbooth_desc
            WHERE pollID=(SELECT MAX(pollID) FROM vbooth_desc);"
        \_ What sort of interface are you using?  Your lang looks like perl,
           but the Perl MySQL DBI interface I've seen has you doing stuff
           more like:
           $sth = $dbh->prepare('select max(pollID) from vbooth_desc');
           $sth->execute;
           while ($hash = $sth->fetchrow_hash) { ... }
2025/04/04 [General] UID:1000 Activity:popular
4/4     

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
	...
2011/12/29-2012/2/6 [Computer/SW/Database] UID:54274 Activity:nil
12/29   Is it worthwhile to use ext4 on VMs? Is Journaling necessary on VMs?
         \_ what about DBs?  I read somewhere ext3 was better for DB voumes (mysql)
	...
2010/11/21-2011/1/13 [Computer/SW/Languages/Web] UID:53988 Activity:moderate
11/21   Lifehacker's recommending Dreamhost as a personal web hosting service.
        Apart from csua, who do you guys use? --erikred
        \_ What do you want to use it for? Do you need CGI or PHP?  My
           brother worked for Dreamhost and said they are unethical. In
           fact, he sued them. This refers to their treatment of customers
           and employees both. I don't know who  or what "Lifehacker" is,
	...
2010/8/12-9/7 [Computer/SW/Languages/Perl] UID:53922 Activity:nil
8/12    Ruby coders, do you mostly DIY your stuff or use the ruby libs out
        there?   How is their quality compared to other libs you have used
        for other langs?  Thx.
        \_ I use Ruby for hobby stuff, etc.  I use libraries for system stuff
           (web access, process, etc.) but that's about it.  Perl libraries are
           much better/more complete.  I assume because of the maturity and
	...
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/10/27-11/3 [Computer/HW/Drives] UID:53474 Activity:nil
10/27   I just read an article that Facebook had moved their database
        to all SSD to speed throughput, but now I can't find it. Has
        anyone else seen this? Any experience with doing this? -ausman
        \_ I hope you're not running mission critical data:
           http://ask.slashdot.org/story/09/10/27/1559248/Reliability-of-PC-Flash-SSDs?from=rss
        \_ Do you have any idea how much storage space is used by Facebook,
	...
2009/9/23-10/5 [Computer/SW/Database] UID:53392 Activity:nil
9/23    I never took CS188, is there a good book that's an intro to formal
        database theory, normalization, etc.?  I've got experience with SQL
        (MySQL & MSSQL), and understand tables, etc.
        \_ You mean CS186?
           \_ Oops, yah.  188 is AI or something?
              \_ That's right.
	...