Paging, directly retrieve paging data through SQL _ MySQL-mysql tutorial

Paging: retrieves paging data using SQL directly bitsCN.com

On a list page, the programmer used the "Wuqi. Webdiyer" paging plug-in, which is slow and has an error. After reading the code, I thought there was too much redundancy, so I decided to optimize it.

After looking for some information from the Internet, consider directly at the bottom of the SQL, directly retrieve the data on the current page, and then bind it, which should be more efficient.

The core SQL query statement is as follows:

Select top @ size * from (@ sqlstring) a where @ key <= (select min (@ key) from (select top @ star @ key from (@ sqlstring) a order by @ key desc) a) and @ key >=( select min (@ key) from (select top @ end @ key from (@ sqlstring) a order by @ key desc) a) order by @ key desc

BitsCN.com