Re: MySQL infinity?

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.