How I can UPDATE DB Row ?

[alfarok]

Hi all ,


How I can UPDATE a row in my DB (MySQL) but Updating starts from End row to first row ..

Example :

If I have 3 rows in my DB and I want to update the last row without any condition ..

[wickning1]

Add an auto_increment column called `id` (or whatever you want), then you can do:

"UPDATE table SET column='value' ORDER BY id DESC LIMIT 1"

[alfarok]

Thanks

Yes that right,

I forgot Order by and I wrote DESC only so, it didn't work


thanks