How to select the last record from MySQL table using SQl syntax.

Question

I have a table with several records. There is an id field. I would like to select the record with the most recent id (i.e. the ighest id).

Any ideas?

Answer 1

User order by with desc order:

select * from t
order by id desc
limit 1

Answer 2

SELECT * 
FROM table_name
ORDER BY id DESC
LIMIT 1

Answer 3

SELECT   *
FROM     table
ORDER BY id DESC
LIMIT    0, 1