Last row in the database

Question

How do you get the last added record/row to the database in MySQL. I have to know this because I only want to update the last added row to the database.

Accepted Answer

Assuming you have an ID column within your table you would do this by:

```
SELECT id FROM table ORDER BY id DESC LIMIT 1;
```

Last row in the database

Solution

Problem