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

Xiaobian to share with you the mysql query the latest 5 records method, I believe most people do not know how, so share this article for your reference, I hope you read this article after a great harvest, let us go to understand it together!

mysql query the latest 5 records method: execute [select * from audio order by id desc LIMIT 5;] statement can be. Among them,[order by id] means query by id, and [LIMIT 5] means limit 5 records.

SQL statement:

select * from audio order by id desc LIMIT 5;

Description:

order by id: query by id (field name)

desc: indicates reverse order

LIMIT 5: Limit 5 records

The above is mysql query the latest 5 records of the method of all the content, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

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.