12

I remember it was Friday, 30 minutes before leaving the office when suddenly someone from the upper management directly asked for my help to mass update something as it is important. By that time our CMS is not capable of doing this so I had to do it straight in the live database.

It was an update query and I decided to type the query in notepad first. when i pasted it in the terminal i didn't noticed i missed the "where" part so i mass updated the status of all our records dating 3 years back.

fuck.. please take note it was on a Friday night.

Comments
  • 0
    @g-m-f I agree with you! but I would rather call it "seasoned" developer 😂
  • 1
    Same boat here.
    Copied this way one tuple to all entries instead of one. 😅
  • 3
    Me to, and most of my colleagues to ;)

    That when you either learn why backups are good to have or praise your luck you or some one else already learned the lesson.

    Its especially fun when not discovered in that me to use the local backup but you have to get one from off site storage, takes about 8 hours to restore those :/.
  • 0
    So many that do this but no one is mentioning BEGIN.. don't commit until you're sure the record count matches what you expect!
Add Comment