15

I goofed up and forgot the WHERE clause in my UPDATE query. Accidentally all of production possibly updated because we don't do test databases. I think it didn't actually go through because I cancelled it but now I need to restore a backup and compare data. Which means explaining this to the co-owner who can help me with a restore. I'm mortified, more so because it was a stupid thing to do to begin with.

Comments
  • 0
    😓
  • 3
    TIL that UPDATE queries don't pass until the whole thing is run so we're in the clear. Time to go home!
  • 1
    Start transaction;
    Manipulate data
    Commit or rollback
  • 3
    We had a similar incident where all client data in the database got UPDATEd to the boss’. We call this the “Agent Smith” effect.
Add Comment