List:General Discussion« Previous MessageNext Message »
From:Rolando Edwards Date:March 20 2007 5:03pm
Subject:Re: about limit
View as plain text  
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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


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