Never forget the WHERE clause on UPDATE :(

  • 8
    I feel you brother.
  • 5
    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 :/
  • 0
    @njmuggio that's exactly what I do.
  • 0
    @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
  • 1
    That's exactly why I always use transactions before I commit queries like these.
  • 0
    Type ZZZUPDATE then erase the ZZZ when you're ready
  • 0
    Or use an ORM!!!
    Gezzus people use an orm!
Add Comment