Mysql Limit Offset

Mysql Limit Offset

Suppose that there are 13 data in the database table student.

Statement 1:select * FROM student limit 9,4

Statement 2:slect * FROM student limit 4 offset 9

Statements 1 and 2 return rows 10th, 11, 12, 13 of the table student

4 in Statement 2 returns 4 rows, 9 means starting from row tenth of the table

paging function via limit and offset or limit only

Suppose Numberperpage represents the number of bars to display per page

pagenumber = page number

Then return to page pagenumber, each page of the number of Numberperpage SQL statement is written as

Statement 3:select * FROM studnet limit (pagenumber-1) *numberperpage,numberperpage

Statement 4:select * FROM student limit numberperpage offset (pagenumber-1) *numberperpage