in reply to memory usage
will give you the first 1000 records. If you then want the next 1000, you can use this:select id, name from businesses limit 1000
Start at 999 (the offset of the first record is 0, I believe), give me 1000 records.select id, name from businesses limit 999,1000
|
|---|