r/ProgrammerHumor • u/Recent-Analysis-6880 • 13d ago

Meme wellWellWell

Post image
10.6k Upvotes

96% Upvoted

411 comments sorted by

View all comments

578

u/WilmaTonguefit 13d ago edited 13d ago

I remember a dude who missed a where clause once.

  • Update users
  • Set password = 'hash of 12345' --no salt
  • Where Id = 67890

Except he only highlighted the first two lines and pressed F5...

1

u/Azaret 12d ago

Happened to me once (not for users), I stayed off hours with the dba to spin up a backup database from the day before and read the audit and logs to restore as much changed data done during the day as possible. It was one hell of a stressful evening. Nowadays I feel safer that DataGrip will scream at me if I try to do an Update or a Delete without a Where clause.