From: Rolando Edwards (redwardsswmx.com)
Date: Tue Mar 20 2007 - 12:03:13 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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" <nikosqbit.gr>
To: mysqllists.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/mysql?unsub=redwardsswmx.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]