MySql Update Query using nested Query

Question

I want to update only the last row from the table logs.. which is arranged in ascending order by ID field.. following query gives the error

update Inventory.logs as a set a.Session=90 where a.ID=(select max(ID) from Inventory.logs)

gives error

you cant specify target table a for update in From Clause

Tables have no order except for that expressly defined in an ORDER BY clause... which, in its own way, is a clue. — Strawberry, Dec 20 '17 at 08:09
Id field is auto inc. so max(ID) will automatically select last row — IUN KHAN, Dec 20 '17 at 08:16

score 0 · Accepted Answer · answered Dec 20 '17 at 08:21

0

Try this code i hope this is hepful

update Inventory.logs set Session=90 order by id desc limit 1

answered Dec 20 '17 at 08:21

Ariel Pepito

1 Answers1