On: Ask HN: What was the worst bug you've ever solved ...

[jacquesm]

I do almost the same thing:

I first write out a select that will show me the records I'm about to modify, then replace the select + fields with the update. And I try to keep modifying live databases using interactive SQL to an absolute minimum.

Check three times, then hit enter.