News for hackers. Stuff that matters.

A comment on An UPDATE without a WHERE, or something close to it. Parent comment

Re:An UPDATE without a WHERE, or something close to it by magicalhippo on Friday October 29, 2021 @10:11AM (#29038607)
Fair point, you don't want those transactions hanging around. Still, I prefer it to the alternative.
[ Parent | on HN ]
Re:An UPDATE without a WHERE, or something close to it by to11mtm on Friday October 29, 2021 @12:37PM (#29040549)
What I usually do instead?

Start with ROLLBACK at the bottom (With a BEGIN TRANSACTION up top if the DB/env warrants it)

Only when I know I'm happy, change the ROLLBACK to a COMMIT.

[ Parent | on HN ]