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" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
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/[EMAIL PROTECTED]