How to make a request from 3 to 10 records and stuff like that?

Question

MySQL

You need to request data in batches.
0,1,2, then 3,4,5, etc.
These are the line numbers, not the id, but the sequence number.

Answer 1

LIMIT will help you with this.
SELECT ... FROM ... LIMIT 0, 3