Deleting / updating too much data in prod. Been there, done that :)
After talking some more experienced devs, they did it too. But now I always wrap the whole thing in a transaction that rolls back immediately. Something like this:
begin tran
// select stuff before
// do delete / update
// run the same select to check and check number of rows affected
rollback tran
Espruino is a JavaScript interpreter for low-power Microcontrollers. This site is both a support community for Espruino and a place to share what you are working on.
Deleting / updating too much data in prod. Been there, done that :)
After talking some more experienced devs, they did it too. But now I always wrap the whole thing in a transaction that rolls back immediately. Something like this:
And re-run with
commit
if it's ok.