How to select the last record from MySQL table using SQL syntax

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 highest id).

Any ideas?

Solution 1:

SELECT * 
FROM table_name
ORDER BY id DESC
LIMIT 1

Solution 2:

You could also do something like this:

SELECT tb1.* FROM Table tb1 WHERE id = (SELECT MAX(tb2.id) FROM Table tb2);

Its useful when you want to make some joins.

Solution 3:

User order by with desc order:

select * from t
order by id desc
limit 1

Solution 4:

SELECT MAX("field name") AS ("primary key") FROM ("table name")

example:

SELECT MAX(brand) AS brandid FROM brand_tbl