List:General Discussion« Previous MessageNext Message »
From:nikos Date:March 20 2007 5:32pm
Subject:Re: about limit
View as plain text  
Hmm!
Clever!

Thanx

Rolando Edwards wrote:
> SELECT ... FROM ... LIMIT 20,100000000;
>
> 100 million is a little exaggeration
> but you can other reasonably high numbers.
>
> Remember, LIMITs are zero-based not 1-based.
>
> ----- Original Message -----
> From: "nikos" <nikos@stripped>
> To: mysql@stripped
> Sent: Tuesday, March 20, 2007 12:50:49 PM (GMT-0500) Auto-Detected
> Subject: about limit
>
> Hello list.
>
> Does any body knows how to select not the LIMIT 20 records but the rest 
> of them?
>
> MySQL version is 4.1.21-standard and I cant make a VIEW.
>
> Thank you
>
> Nikos
>
>   
Thread
about limitnikos20 Mar
  • Re: about limitKevin Hunter20 Mar
  • Re: about limitRolando Edwards20 Mar
    • Re: about limitnikos20 Mar
    • Re: about limitDan Buettner20 Mar
      • Re: about limitPeter Brawley20 Mar