How to select the last record from a 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 highest id).

Any ideas?

Answer 1

SELECT * FROM table_name ORDER BY id DESC LIMIT 1 

Answer 2

User order with desc :

 select * from t order by id desc limit 1 

Answer 3

You can also do something like this:

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

This is useful when you want to make multiple connections.

Answer 4

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

Example:

 SELECT MAX(brand) AS brandid FROM brand_tbl 

Answer 5

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

Answer 6

I used the following two:

 1 - select id from table_name where id = (select MAX(id) from table_name) 2 - select id from table_name order by id desc limit 0, 1