sql - SQLite: Combine SELECT and DELETE in one statement

Question

I need to run two statements like so:

Select amount from db where ID=5
DELETE from db where ID=5

Currently I prepare and run two different statements. I wonder if there is a way to combine it in one statement.

Basically all I need to do is to get an amount column from the row before it is deleted.

Answer 1

SQLite does not support this extension to standard SQL -- you do have to use both statements, SELECT first, DELETE next. You can wrap them in a transaction, of course, (BEGIN and COMMIT statements before and after will guarantee that), to guarantee atomicity and consistency.