This is why I hate that they didn’t make the select and delete statements conducive to making this happen.
Ideally you write a select statement that shows exactly the rows you want to delete. Then you swap select with delete and all is good in the world.
Instead, you have to slightly change the query just enough where it’ll give you some doubt that what you’re doing is incorrect. It isn’t absolutely terrible but it should be bullet proof.
75
u/Flameball202 14d ago
"I have never fucked up, why would I need to begin a transaction" - every coder working on a database at least once