Select only N rows at a time (MySQL)

Question

I am looking for a way to extract all the data from a huge table into smaller pieces.

Please inform.

Answer 1

To answer a question from the title
use the LIMIT operator

SELECT * FROM table LIMIT 0,20 

as for one of the body, it is also wide to ask for an example of a certain code, isn't it?