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: 
```
SELECT MAX(ID) FROM tablename LIMIT 1

```

Use this query to find the highest ID in the MySQL table.
This is the only proposed method who actually selects the whole row, not only the max(id) field. It uses a subquery

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