What is the usage of mysql top

Usage of mysql top: The usage of select top in mysql is different from that of mysql server. To query the first 3 pieces of data, the code is [select * from table name limit 1,3].

Usage of mysql top:

The usage of select top in mysql is different from that of mysql server.

When querying the first three pieces of data, you cannot use

select top 3 * from 表名

in mysql. Instead, you should use

select * from 表名 limit 1,3

to query the first M pieces of data. Then let the first page display M Article

select * from 表名 limit 1, M

Related free learning recommendations: mysql number Database(Video)

The above is the detailed content of What is the usage of mysql top. For more information, please follow other related articles on the PHP Chinese website!