Re: How does one ... - Dirk Hillbrecht - com.mysql.lists.java

13 messages in com.mysql.lists.javaRe: How does one ...

From	Sent On	Attachments
Jeff Mathis	22 Aug 2003 10:06
Mark Matthews	22 Aug 2003 13:19
Jeff Mathis	22 Aug 2003 13:23
Mufaddal Khumri	24 Sep 2003 22:42
Mufaddal Khumri	25 Sep 2003 00:00
Mufaddal Khumri	25 Sep 2003 01:53
John Beveridge	25 Sep 2003 15:16
Jeff Mathis	30 Sep 2003 12:27
Mufaddal Khumri	08 Oct 2003 21:25
Mufaddal Khumri	08 Oct 2003 21:36
Dirk Hillbrecht	09 Oct 2003 09:57
Dirk Hillbrecht	09 Oct 2003 10:16
Fouche du Preez	14 Oct 2003 02:25

Subject:	Re: How does one ...
From:	Dirk Hillbrecht (dh...@cantamen.de)
Date:	10/09/2003 09:57:05 AM
List:	com.mysql.lists.java

Hi,

Is it possible to formulate a query telling mysql that you want 20 records starting at offset 35 (not ID 35) ? (For example the offset 35 into the USER table might map to record ID 40. So you want 20 records starting from record ID 40.)

This is in principle impossible, as you cannot make any assumptions on a "natural" order of the rows in a table. If you want to have a certain range of the table, sort it by some column ("ID" would not be the least sensible candidate...) and then use the "limit" clause to get only a part of the whole thing.

Best regards, Dirk