mysql of limit of the first few record statements

2020-05-09 19:26:31
OfStack

                    MySql does not provide the top method. But he has the limit method that provides the same functionality.

SELECT * FROM `tfidf` order by weight desc limit 1, 10830 

SELECT * FROM `tfidf` order by weight desc limit 10

mysql optimizes five methods for limit query statements
MYSQL slow problem record database statements
Record the actual combat record of MySQL Slave library once
The record is updated if mysql exists and sql of the record is inserted if it does not
The mysql query statement USES limit to limit the number of rows in the query