MySQL Paging query limit

Forget the limit and record it every time.

Paged query (limit start line, query a few lines)

--start line starting from 0

--Pagination: The current page shows how many bars per page

--Paged Query the current page of the data Sql:select * from Student LIMIT (current page-1) * How many bars per page, how many bars per page;

--Demand: Query 1th, 2 records (data on page 1th) SELECT * from student LIMIT 0, 2;

--Query 3rd, 4 records (Data on page 2nd) SELECT * FROM Student LIMIT 2, 2;

--Query 5th, 6 Records (data on page 3rd) SELECT * FROM Student LIMIT 4, 2;

--Query 7th, 8 records (no records not shown) SELECT * FROM student LIMIT 6, 2;

MySQL Paging query limit