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

  • erogenouswarzone@lemmy.ml
    link
    fedilink
    arrow-up
    40
    ·
    edit-2
    11 months ago

    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
      link
      fedilink
      arrow-up
      9
      ·
      11 months ago

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

      • Azzy@beehaw.org
        link
        fedilink
        arrow-up
        6
        ·
        edit-2
        11 months ago

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

    • FredericChopin_@feddit.ukOP
      link
      fedilink
      arrow-up
      6
      ·
      11 months ago

      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
        link
        fedilink
        arrow-up
        6
        ·
        11 months 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.