How to delete the last user entry?

Question

SQL

The task - to delete the last record of the user from the table.
I try like this

DELETE FROM `all` WHERE id = (SELECT id FROM `all` where userid='5' ORDER BY id DESC LIMIT 1)

But I get error
#1093 - You can't specify target table 'all' for update in FROM clause
subquery

SELECT id FROM `all` where userid='5' ORDER BY id DESC LIMIT 1

gives the correct id. Where did I go wrong with my design?

Answer 1

DELETE FROM all WHERE user_id=5 ORDER BY id DESC LIMIT 1