Ill got first.
I felt a bit nauseous coming back from work one day last week so I went straight to bed without eating.
The next morning I was quite hungry and once I had driven to work I went to a Tesco Superstore with a hankering for a banana.
Cue stupidity. I went to the adjoining Costa to use the bathroom and quickly scanned for bananas, which they didn’t have so I bought an overpriced toastie instead.
A few days later I’m sat mind wandering and I think I was in Tesco with thousands of bananas but I just checked Costa. Sigh
I ran an UPDATE without a WHERE clause.
Edit: Remember kids, when updating a database, always write your WHERE before your FROM.
I ran the wrong DELETE statement today and accidentally deleted around 2.7 million records today instead of 13 …
yikes, I’m so sorry. all I can say is “BEGIN TRANSACTION”…
This is one of my fears.
Oof.
To share another in a similar vain.
I work in Visual Studio Professional and I may have used the find and replace feature but forgot to keep it for current file and the entire solution was affected.
I was mid session so couldn’t really role back the commit so I just had to laboriously check all the files I’d modified until the errors went away.
Ouch.
We had to roll back the prod database to the last save. Only amounted to 15 or 20 minutes, and I don’t think anything was super affected, but then I was that guy.