How to query the latest 5 records in mysql

Mysql method to query the latest 5 records: execute the [select * from audio order by id desc LIMIT 5;] statement. Among them, [order by id] means querying by id, and [LIMIT 5] means limiting 5 records.

sql statement:

(recommended tutorial: mysql tutorial)

select * from audio order by id desc LIMIT 5;

Instructions:

order by id: query by id (field name)

desc: indicates reverse order

LIMIT 5: limit 5 records

Related recommendations:phptraining

The above is the detailed content of How to query the latest 5 records in mysql. For more information, please follow other related articles on the PHP Chinese website!