28
indigo
7y

My worst dev sin was leaving out the 'WHERE' in a SQL update statement on a production database

Set every booking to be owned by the same sales consultant 👀

Comments
  • 4
    I did this once and ever since I run selects first to make sure i dont fuck up

    That experience scarred me for life
  • 1
    SQL should really have some way to prevent things like these. Like mongodb has the { multi: true} option when you're running any kind of update. If not specified, it will only update the first matching document.
Add Comment