How to make a SELECT MAX(id) inside UPDATE?

Question

I'm starting in Mysql and I'm trying to find a way to select the maximum id inside update. This is what I tried but it doesn't work.

UPDATE `chatMessages` 
SET send = 'true' 
WHERE id = (SELECT MAX(id) FROM `chatMessages`)

score 1 · Accepted Answer · answered Sep 10 '21 at 22:47

1

Use ORDER BY and LIMIT.

UPDATE `chatMessages` 
SET send = 'true' 
ORDER BY id DESC
LIMIT 1

answered Sep 10 '21 at 22:47

Barmar

Great, I don't know why the way I did it didn't work, as much as it seems to be right, thanks – God of all wars Sep 10 '21 at 22:53
MySQL doesn't allow you to use a subquery in the same table in the `WHERE` clause. – Barmar Sep 11 '21 at 01:01
See https://stackoverflow.com/questions/4429319/you-cant-specify-target-table-for-update-in-from-clause – Barmar Sep 11 '21 at 01:01

1 Answers1