Shulou(Shulou.com)05/31 Report--

This article is about how mysql queries the latest record. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

In mysql, you can use select query statements with "order by" and limit clauses to query the latest record, with the syntax "select * from table name order by time field desc limit 0Jing 1;".

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

How does mysql query the latest record

Use order by time desc to query data according to time descending order in adding restrictions limit 0J1 condition to select a piece of data, that is, the latest record in the mysql database, starting from the first piece of data. The complete statement is as follows:

Select * from table name order by time field desc limit 0recover1

Examples are as follows:

MYSQL queries the latest record of different users

After the query results, the time is sorted and the first item is taken (only one item can be obtained, and the records of different customers cannot be queried).

SELECT CUSTOMER_ID,CONTENT,MODIFY_TIME FROM `service_ records` ORDER BY MODIFY_TIME DESC LIMIT 1

Query results:

Thank you for reading! This is the end of this article on "how to query the latest record in mysql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

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.