59
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 01 Aug 2023
59 points (92.8% liked)
Asklemmy
43750 readers
1118 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 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.