News for hackers. Stuff that matters.
Re:An UPDATE without a WHERE, or something close to it by stuartd on Friday October 29, 2021 @04:38PM (#29043277)
I learned this technique the first time I actually worked with a real DBA many years ago and have used it ever since: one thing I like about it is that is mitigates the ‘fear factor’ of production changes, as (topically) ‘fear is the mind killer’ and makes mistakes more likely. Then there’s mitigating ‘complacency’ - “I do this all the time” - which can also lead to mistakes.

And yes, before that I had run an UPDATE without a WHERE in production..

There are no comments on this comment yet.