There is a big table. How to select from it all the data in a cycle, in batches of 10 records?

Question

PHP

It is clear that you need to use LIMIT and OFFSET, but I don’t understand how to shift OFFSET?
Explain the principle or poke into a code example.
Thank you.

Answer 1

<?php
$limit = 10000;
$offset = 0;
do {
$data = $db->query("SELECT * FROM `tbl` ORDER BY `id` ASC LIMIT $limit OFFSET $offset")->fetchAll();
$offset += count($data); 
}
while(count($data));

Answer 2

Not necessary.
How much data you need - so much and request, all at once, without any limits.

Answer 3

I would like to leave it here.
Thanks everyone for the replies.