MySQL database page

Select * FromTablename limit pagesize*Pageno, pagesize # MySQL database page, which can automatically calculate the deletion records # pagesize*Pageno refers to the number of records that deviate from the first record in the record set.

Okay, I want to admit that this was found from an unpleasant debate. As a result, I am wrong. MySQL can simply implement paging using such SQL statements, my understanding of limit is equivalent to top. However, the use of top can only specify one number. It retrieves N records from the record set. In terms of semantics, it cannot help to build a record set. In MySQL's limit semantics, limit is directly involved in the construction of record sets.

 

Finally: knowing is knowing, not knowing, or knowing