Use the select statement to implement mysql paging Query

Mysql paging query is a common problem. How can this problem be achieved? The following describes how to implement mysql paging query.

Mysql uses a feature of the select statement to conveniently implement paging of query results. The select statement implements the mysql paging query syntax:

 
 

  
  
SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [HIGH_PRIORITY]  
  
  
[DISTINCT | DISTINCTROW | ALL]  
  
  
select_expression,...  
  
  
[INTO OUTFILE 'file_name' export_options]  
  
  
[FROM table_references  
  
  
[WHERE where_definition]  
  
  
[GROUP BY col_name,...]  
  
  
[HAVING where_definition]  
  
  
[ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] ,...]  
  
  
[LIMIT [offset,] rows]  
  
  
[PROCEDURE procedure_name] ]  
 
 

The LIMIT clause can be used to LIMIT the number of data returned by the SELECT statement. It has one or two parameters. If two parameters are provided, the first parameter specifies the position of the first row returned in all data, note not 1 from 0). The second parameter specifies the maximum number of returned rows. For example:

 
 

  
  
Select * from table LIMIT 5, 10; # return data in rows 6-15
  
  
Select * from table LIMIT 5; # Return the first five rows
  
  
Select * from table LIMIT; # Return the first five rows
 
 

The above is the mysql paging Query Process.

Take you to the DB2 Character Set and MySql Character Set

Using SSIS to build MySQL monitoring tools

Differences between single-column and combined indexes in MySQL

Mysql table alias usage

What is Mysql table sharding?