Re: MySQL infinity?

>From http://dev.mysql.com/doc/mysql/en/select.html about a quarter of
the way down:

 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;

A little higher than 4 billion, but probably similar results.
-r

On 6/17/05, Brandon Carlson <brandon-+k24AcDEvnDQT0dZR+AlfA@xxxxxxxxxxxxxxxx> 
wrote:
> I can't remember where I read this, but I seem to recall that mySQL will
> treat any number greater than the storage capability of the data type as
> infinity.
> 
> Example: int is a 32 bit number or 2^32 or 4,294,967,296, so
> 4,294,967,297 and above are treated as infinity.
> 
> Of course, I can't remember where I saw this, but I'm pretty sure it was
> in my Mysql book (which I can't find right now :( )
> 
> 
> Brandon
> 
> On Thu, 2005-06-16 at 23:51, Blaine Garrett wrote:
> > Cool. I guess I will stick to my original solution.
> > That seems odd they have a wide range of math functions, but not infinity,
> > especially cases like this.
> >
> > Thanks for the info Paul,
> >
> > Blaine
> >
> >
> > Quoting Paul Fierro <pablo-JrhHNAPLzIdBDgjK7y7TUQ@xxxxxxxxxxxxxxxx>:
> >
> > > 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.
> > >
> > >
> >
> >
> > --
> > Blaine Garrett
> > Chief Web Applications Developer
> > JR Computer Associates INC
> > http://jrcorps.com
> > blaine-4hELYU93S8xBDgjK7y7TUQ@xxxxxxxxxxxxxxxx
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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.
> --
> Brandon Carlson
> CEO - Aphion Inc
> www.aphion.com
> brandon-+k24AcDEvnDQT0dZR+AlfA@xxxxxxxxxxxxxxxx
> 651-429-9888
> AIM: bcarl314pi
> Yahoo: bcarl314
> 
> 
> ---------------------------------------------------------------------
> 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.
> 
>

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