IntelliMoonSpirit
Reputation: 63
How get all the values in the rows just deleted? - sqlite
I deleted a row of my table with the where clause in Python sqlite3, then how can I get all the column values of that row?
Upvotes: 0
Views: 114
Answers (1)
9000
Reputation: 40894
Apparently, this is impossible: SQLite's deletehas no returning clause.
Do a select, then do a delete, in the same transaction.
Upvotes: 2
Related Questions
- Return deleted rows in sqlite
- How do i delete these rows in SQLite database?
- python sqlite3 DELETE FROM table row if exists
- Python SQLite delete rows IN
- Python: retrieve number of rows affected with SQL DELETE query
- Delete everything from table based on it's referential data
- Returning Deleted Rows in SQLite
- Python sqlite3 - How to reset the values of an INTEGER PRIMARY KEY id after deleting some rows
- Deleting data from sqlite database
- I can't delete all rows in a sqlite table using python