Mysql uses limit instead of top

Mysql uses limit instead of top mysql. Instead, it uses limit instead of www.2cto.com. to query the first 10 records, mysql uses limit 10 LIMIT to implement top N queries, you can also query records from m to N (a certain segment). The specific syntax is as follows: SELECT * from mytable order by afield limit offset, in recnum, offset starts from the number of records (M + 1) and recnum is the number of returned records. For example, select * from mytable order by afield limit 2, 5 indicates the five records starting from the first 3rd records.