How can I select the row with the highest ID in My

Question

How can I select the row with the highest ID in MySQL? This is my current code:

SELECT * FROM permlog WHERE max(id)

Errors come up, can someone help me?

Answer 1

SELECT *
FROM permlog
WHERE id = ( SELECT MAX(id) FROM permlog ) ;

This would return all rows with highest id, in case id column is not constrained to be unique.

Answer 2

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