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

Editor to share with you the method of mysql query the first 20 records, I hope you will learn a lot after reading this article, let's discuss it together!

Mysql queries the first 20 records by executing the [select * from no_primary_key order by id limit 10;] command to view. Execute the [show create table no_primary_key] command to view the table structure.

Specific methods:

To display the first 20 records from id=1 to id=20, execute the command:

Select * from no_primary_key order by id limit 10

Display 20 records at will

Select * from no_primary_key limit 20

Note: you can't replace select; with sel, but you can use desc instead of describe.

Desc no_primary_key;show create table no_primary_key; # shows the detailed list structure after reading this article, I believe you have a certain understanding of the mysql query method of the first 20 records, want to know more related knowledge, 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.