Hacker News new | ask | show | jobs
by kspy 2782 days ago
First job out of college working at a healthcare organization, our healthcare system db was mssql. There was a column in one of the tables called `recordDeleted` which basically controlled whether or not the document would show up on the front end. I ran an update statement and forgot a where clause (specifying which records I needed to modify), setting thousands of records in prod to 'record delete' status, causing a whirlwind of confusion as to what was happening while workers were servicing clients.