Menu
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?
985
You can use ORDER BY clause or aggregate function MAX() to select the maximum value.
To find the maximum value of a column, use the MAX() aggregate function; it takes a column name or an expression to find the maximum value. In our example, the subquery returns the highest number in the column grade (subquery: SELECT MAX(grade) FROM student ).
SELECT * FROM permlog ORDER BY id DESC LIMIT 0, 1 if it's just the highest ID you want. and ID is unique/auto_increment:
SELECT MAX(ID) FROM tablename If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
