Re: How to list 60,000 records?

[Paul DuBois]

At 9:31 PM -0400 6/12/1999, Para-dox wrote:
>how can I tell it to get rows 1000 through 2000 ?


SELECT ..... LIMIT 1000, 1000;

First number of offset (beginning at 0) into the rows selected,
second number is the number of rows to return.  Check the SELECT
description in Chapter 7 of the MySQL Reference Manual.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/