I ran an UPDATE without a WHERE clause.
Edit: Remember kids, when updating a database, always write your WHERE before your FROM.
this post was submitted on 01 Aug 2023
58 points (91.4% liked)
Asklemmy
43939 readers
428 users here now
A loosely moderated place to ask open-ended questions
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
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”…
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.
This is one of my fears.
I got cancer while living in a country without socialized medicine. Yup, pretty dumb.
Well that was silly wasn’t it.
I hope you’re kicking cancers ass.
I'm so sorry. US? I got appendicitis here, and it has really ruined any chance of being able to ever retire.
Yup, it's pretty brutal. I'm sorry to hear that for you, too. I have spent my life being furious at how horribly this nation treats people with difficult diseases, and now I'm facing it myself. Feels pretty fucking pointless to keep trying, personally.
I know the feeling. Ironically, this very line of thinking got me sent to the psych ward (which was worse than jail and less helpful) and slapped with another bill. The whole system is designed to exploit, not to cure.
I hope you find yourself in good health again. This system is atrocious, nobody deserves to go without, or to choose health vs. living costs, or to not retire because they got appendicitis. This level of greed and cruelty is absolutely horrifying.
Puked on my crushes foot at a party a few weeks back. Thankfully she’s cool and we still hang out lol
This is just making memories haha
Puked on a girl once when I was young. I’m sure they get over it, I never saw her again but I’m sure she’s fine.
Oh I did this but this was with a girl I was fwb with.
She invited me over for a party but it was actually just her and her best friend and her boyfriend so I ended up getting super drunk that at the end when her dad came home and she introduced me, I puked on HIS shoes.
That was the end of our relationship as humans. She blocked me on everything haha.
I didn't put on sunscreen when I was outdoors for an extended period because it was cloudy. I knew it was a dumb move. I did it anyway. And I definitely paid for it with the worst sunburn I've had in literal years. Will not be making that stupid move again for quite a while!
Aww I’m sorry i can relate. I’ve been burned more than enough times that I just don’t go in the sun too much. Family want to sit by the pool, crack on then, I’ll go for a walk hopping from shade to shade.
I too was dumb but more I didn’t like the feeling of sun cream on my skin. I don’t like burning either so avoiding the sun where possible is the way.
That said I do like to run in it occasionally, I stop running but then it gets warm and I get the urge.
I reply to Lemmy comments that I shouldn't
I sometimes can't resist feeding the trolls.
Same. I need to use the block feature more. I'd hate to see this become reddit 2.0
I have been trying to be better at refraining from replying to those type of comments and getting better at reporting them.
Man, I'd forgotten about what happened yesterday until I saw this post.
Yesterday after work, heading to pick my dog up from daycare. I'm sitting at a red light, front of the line. A song comes on that I don't want to hear so I'm using the wheel controls to hit next song a few times, and I swear out of the corner of my eye I see the car waiting in the lane to the right of me move forward, so of course I look up and step on the gas.
The light was still red. I didn't see it until I was through the intersection.
Luckily there was no cross traffic, but man was I breathing hard when I realized how lucky I'd been.
I've done that. Was looking at the radio to change songs while going through an intersection. My brain was on autopilot and I followed a guy running a red turn signal. Just about had a head on crash with the straight through traffic 😬
On my drive home from work there's this one light that lets me turn left and people going straight have to wait longer. I'm so terrified that I'm going to cause someone to do what you did.
Someone parked their motorbike in front of the door to my house (there are no yards in my country, your door is right up against the street), so I couldn't open the door or get in. The owner was nowhere to be found.
So of course they locked the steering, so you can't roll it out of the way. Being still on autopilot after driving through much traffic, I just sort of automatically tried to pick up the motorcycle and move it.
Surprisingly, I succeeded -- at least for a few seconds. After moving it only a meter or so, I lost my balance and fell over, with the motorbike landing on me. I earned some impressive bruises for my foolishness.
Thankfully though, this became the most interesting neighborhood gossip for some time, so the person responsible felt too ashamed to keep parking there.
I noticed a fire on a woody and dry beach caused by someone else’s old campfire and tried putting it out with a water bottle and sand.
Turns out the sand was actually just small thinly ground wood chips. Tried picking up a stick to separate the ashes, severely burnt my entire hand.
I thought I was Smoky the bear but instead I got smoked.
yo mama.
also, i super drunkenly tried to clear up a mono-platonic girl-boy situation at a party two weeks ago. the next day i felt i had to apologise; so i did.
i'm medium old, so i should know better by now.
Good on you for apologizing. Not many people would, but it really is the best form of self-therapy.
I opened this thread.
Well at least you didn’t buy an overpriced toastie. I mean that shit is truly wack.
Hey the thread isn't for really dumb stuff, just pretty dumb stuff.
It was mediocre too.
I like to always try and find a positive though and in this I’m telling myself it’s better health wise than a double sausage and egg McMuffin.
I ate whole of creamy cake, while being lactose intolerant.
I was distracted watching TV. Both my sinus nasal spray and vape were on the table.
I realized I was congested and needed the spray. As a heavy smoker, I am used to grabbing my device mindlessly all day.
So I picked up the vape and proceeded to stick it up my nose because my brain mixed up what I was doing.
I laughed really hard.
I got a used car at the end of 2022. I am just now accepting the fact that it was a stupid decision. I'm already upside down on the loan and now the turbo is having issues that may be costly to repair. I'm wanting to move soon to a place where I won't need a car anymore, but now I'm realizing selling it isn't going to be quite as straight forward as I initially thought.
Yesterday I had to finish my work at 6 to attend a 3 hours language class at 7 and I was dissociating so hard that when I left I had to come back to work to grab something I forgot, then I freaked out thinking I lost a key to my office (they were in the other pocket). Then halfway to the language school I realized that I lost my coat somewhere along the way. Then I managed to get lost somehow on my way to the language school. After the class I got lost twice when I was exiting the fckin building! I was like "get yourself together FFS!" lol Feel so stupid even now while I'm writing this.
I lost my coat somewhere along the way
This reminds me of a friend after a long night out. I let them borrow my (thankfully cheap) coat because it was cold out, and we hopped on a bus to get home. I look over and the coat was gone. Friend had no clue what happened. We were both super tired and out of it but yeah it just disappeared on the journey lol.
I got shampoo in my eye while showering the other day. It was just a milidy painful inconvenience, but felt so stupid because it hadn't happened in years til then.
I took over a colleague's reporting as they're leaving and with the press of a button all 4 reports broke for the whole business. During peak monthly reporting time. Whoopsie. Now waiting for IT to fix everything, which might take a while.
Also I walk into things quite a lot.
I'm not sure at the moment, but I'm sure that at some point in the coming days/weeks/years I'll realize what I had done and forever remember it from then on.