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

2003/1/7-8 [Computer/SW/Database] UID:27016 Activity:moderate
1/7     SQL/DB Question: Is there any way to do a query and only return a
        certain set of results? Like the results between 20-30. Kinda like
        what Google does when you choose what subset of results you want
        to see. It seems like they don't do one query and cache it,
        they do it dynamically based on the parameters. And I can't use
        something like Scrollable ResultSets because my program has to
        be stateless and the query can be done at any time. Did that make
        sense?
        \_ Yes.
        \_ Create an incremental column and use BETWEEN.
          \_ It's not the rows in the DB table I want, it's going to be
             the rows that are returned by the SQL Query. But thanks. -op
          \_ I meant create a computed incrementing column in the select
             clause.
        \_ use 'limit' and 'offset'.  Not all db support it and this is
           not a standard sql.
2025/04/04 [General] UID:1000 Activity:popular
4/4     

You may also be interested in these entries...
2005/7/22-25 [Computer/SW/Database, Computer/SW/Languages/Misc] UID:38783 Activity:kinda low
7/22    When I do SELECT AVG(col) FROM table, where col is integer, it takes
        2 minutes and returns a float type. I'm suspecting part of the
        problem is that it's doing floating point add? How do I make it
        faster? Thanks.
        \_ How many rows it is querying over?
           \_ about ~2,000,000
	...
2005/4/8-10 [Computer/SW/Database] UID:37118 Activity:moderate
4/8     Anyone reccomend a good mysql programming tutorial that goes
        beyond the basic select statements ? I would like to be able
        to do a distinct on specific column and then do a count of all
        the rows that have the corresponding values. thanks  --ramberg
        \_ select t.col, count(*) from tble t group by t.col;
           \_ thanks. --ramberg
	...
2004/3/25 [Computer/SW/Database] UID:12849 Activity:nil
3/25    Ok please tell me the pros/cons of mysql vs. postgreSQL. For me
        speed is really really important. On the other hand, packaging
        (ease of install, consistent commands, etc) is also very important
        for development. I've just tried mysql for the first time and I'm
        NOT very impressed. The documentation that came with it was outdated
        (some of the tutorials didn't work) and it didn't even pass all of
	...
2002/2/12-13 [Computer/Domains] UID:23848 Activity:high
2/12    Is there a way to find all the internet host names (at least those
        known to my DNS server) that contain a certain string?  E.g. I want to
        find all of <DEAD>www.fooinc.com<DEAD> <DEAD>www.foo-systems.com<DEAD> <DEAD>www.foo-college.edu<DEAD>
        http://www.foo.net etc.  Thanks.
        \_ No, think about it, you would have to query every authoritative
           DNS server in the internet.
	...
2001/6/19 [Computer/SW/Database] UID:21575 Activity:high
6/19    database question
        is there a way to have a unique ID span a database as opposed to only a
        table... (so that no 2 tables will have records tied using the same
        "autonumber")
        \_ you could have a skinny table of just ID's and have all other tables
           that you care about reference this column. I'm not sure if that
	...