How to use LIMIT for pagination in MySQL?

In MySQL, the LIMIT keyword can be used to achieve pagination for queries. The syntax for LIMIT is as follows:

SELECT column1, column2, ...
FROM table
LIMIT offset, count;

The offset parameter indicates the starting position of the result set, while the count parameter indicates the number of rows to be returned.

For example, to retrieve the first 5 records from the table, you can use the following statement:

SELECT * FROM table
LIMIT 0, 5;

To query records 6 through 10 of the result set, you can use the following statement:

SELECT * FROM table
LIMIT 5, 5;

This allows for pagination in MySQL using the LIMIT clause.