News for hackers. Stuff that matters.
Re:An UPDATE without a WHERE, or something close to it by eyelidlessness on Friday October 29, 2021 @08:58PM (#29045108)
I don’t even do this, it’s too easy to sidestep. For example using any GUI client where the current selection or statement is executed by default. (Yes this is very useful, no I am not interested in being convinced not to use these tools thank you.)

Instead I do my dry run queries with a read only user and I select the affected data, often using CTEs (or temp tables where performance is an issue) to model any intermediate state. I don’t ever run any writes of this kind without review, backups, and automation.

There are no comments on this comment yet.