Implement the LIMIT Function for MySQL Paging

The following article mainly introduces the actual MySQL paging operation solution. In fact, the simplest way to implement MySQL paging is to use the mysql database LIMIT function, LIMIT [offset,] rows can search for N records starting from the M records in the MySQL database table:

 
 


  
  
SELECT * FROM table name limit m, N

 
 

For example, if the primary key of the table Sys_option is sys_id, 20 records are retrieved from the first 10th records. The statement is as follows:

 
 


  
  
Select * from sys_option limit 10, 20

  
  
Select * from table [query condition] order by id limit ?,?

 
 

The above content is an introduction to MySQL paging. I hope you will get some benefits.