mysql paging

Collection Like

Mysql paging queries can be implemented through LIMIT statements, OFFSET statements, using variables and using subqueries. Detailed introduction: 1. The LIMIT statement can limit the number of query results and specify which row to start returning results; 2. The OFFSET statement can directly specify the starting number of rows to be returned without calculating the offset; 3. Use variables, use MySQL user variables to achieve this. User variables can hold a value in a query and use it in subsequent queries. Use MySQL user variables to achieve this. User variables can hold a value in a query and use it in subsequent queries.