Re: MySQL infinity?

On 06/16/2005 12:19 PM, Blaine Garrett 
<blaine-4hELYU93S8xBDgjK7y7TUQ@xxxxxxxxxxxxxxxx> wrote:

> I think maybe I will just stick to the "really large" number thing instead of
> COUNT or other methods.

The MySQL manual suggests doing exactly that:

    To retrieve all rows from a certain offset up to the end of the result
    set, you can use some large number for the second parameter. This
    statement retrieves all rows from the 96th row to the last:

    mysql> SELECT * FROM table LIMIT 95,18446744073709551615;

http://dev.mysql.com/doc/mysql/en/select.html

Paul


---------------------------------------------------------------------
To unsubscribe, e-mail: talk-unsubscribe-4zcLI8jJc/rYtjvyW6yDsg@xxxxxxxxxxxxxxxx

Please read and follow the list guidelines:
  http://www.tcphp.org/mailing_list/guidelines

The tcphp.org mailing list is sponsored by pajunas interactive, inc.