List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 13 1999 1:51am
Subject:Re: How to list 60,000 records?
View as plain text  
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/
Thread
How to list 60,000 records?Para-dox12 Jun
  • Re: How to list 60,000 records?Para-dox12 Jun
  • Re: How to list 60,000 records?Para-dox13 Jun
  • Re: How to list 60,000 records?Fred Read13 Jun
  • Re: How to list 60,000 records?Para-dox13 Jun
  • Re: How to list 60,000 records?Fred Read13 Jun
  • Re: How to list 60,000 records?Para-dox13 Jun
  • Re: How to list 60,000 records?Fred Read13 Jun
  • Re: How to list 60,000 records?Para-dox13 Jun
  • Re: How to list 60,000 records?Para-dox13 Jun
    • Re: How to list 60,000 records?Paul DuBois13 Jun