SQLite Forum

Retrieve a record and delete it
Login
Like Harald alrady mentioned since 3.35.0 you can write:

DELETE FROM dickiedee WHERE yummy=fruitcake RETURNING whopee

This is really useful and I do it all the time.