Never forget the WHERE clause on UPDATE :(

I feel you brother.

Been there... Done that.... Didn't even notice it until i came back to the office the next day to see that ove nigh there were thausands of notification mails sent again :/

@njmuggio that's exactly what I do.

@njmuggio i have to "Update" rarely, I think that's the reason why I forget it so often, but it never happened on very important data and mostly I have auto backups 👍
I should try to get used to it to start with update where, sounds interesting :D

That's exactly why I always use transactions before I commit queries like these.

Type ZZZUPDATE then erase the ZZZ when you're ready

Or use an ORM!!!
Gezzus people use an orm!