Shulou(Shulou.com)06/01 Report--

The editor will share with you how to use top in mysql. I hope you will gain a lot after reading this article. Let's discuss it together.

The usage of mysql top: there is a difference between the usage of select top and mysql server in mysql. The first three pieces of data are queried, and the code is [select * from table name limit 1 Magi 3].

The usage of mysql top:

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

Cannot be used in mysql when querying the first three pieces of data

Select top 3 * from table name

Instead, you should use

Select * from table name limit 1Jue 3

Query the first M pieces of data, then let the first page display M pieces

Select * from table name limit 1, M after reading this article, I believe you have a certain understanding of how to use top in mysql, want to know more about it, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.