An UPDATE without a WHERE, or something close to it

Re:An UPDATE without a WHERE, or something close to it by jesterpm on Friday October 29, 2021 @05:03PM (#29043509)

I take a similar approach. I usually want to see what I'm about to change before I change it, so I'll SELECT * FROM ... WHERE ... , then go back in the command history and delete the SELECT FROM.

[ Parent | on HN ]

Re:An UPDATE without a WHERE, or something close to it by meowface on Friday October 29, 2021 @08:12PM (#29044901)

Same. (Also for DELETEs.) I would guess this is what a high percentage of people do.

[ Parent | on HN ]