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.
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.
I ran the wrong DELETE statement today and accidentally deleted around 2.7 million records today instead of 13 …
