Asklemmy

43835 readers

759 users here now

A loosely moderated place to ask open-ended questions

Search asklemmy 🔍

If your post meets the following criteria, it's welcome here!

Open-ended question
Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
Not ad nauseam inducing: please make sure it is a question that would be new to most members
An actual topic of discussion

Looking for support?

Looking for a community?

Lemmyverse: community search
sub.rehab: maps old subreddits to fediverse options, marks official as such
!lemmy411@lemmy.ca: a community for finding communities

~Icon~ ~by~ ~@Double_A@discuss.tchncs.de~

founded 5 years ago

MODERATORS

Whats something pretty dumb you’ve done recently? (feddit.uk)

submitted 1 year ago by FredericChopin_@feddit.uk to c/asklemmy@lemmy.ml

43 comments fedilink hide all child comments

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

you are viewing a single comment's thread
view the rest of the comments

[–] erogenouswarzone@lemmy.ml 40 points 1 year ago* (last edited 1 year ago) (3 children)

I ran an UPDATE without a WHERE clause.

Edit: Remember kids, when updating a database, always write your WHERE before your FROM.

[–] Cuteblooded@feddit.nl 9 points 1 year ago (1 children)

I ran the wrong DELETE statement today and accidentally deleted around 2.7 million records today instead of 13 ...

[–] AzzyDev@beehaw.org 6 points 1 year ago* (last edited 1 year ago)

yikes, I’m so sorry. all I can say is “BEGIN TRANSACTION”…

[–] LeftHandedWave@lemm.ee 7 points 1 year ago

This is one of my fears.

[–] FredericChopin_@feddit.uk 6 points 1 year ago (1 children)

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.

[–] erogenouswarzone@lemmy.ml 6 points 1 year ago

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.