Forgot to add a WHERE clause in my UPDATE query for Prod DB, that contained 100K+ Records.

FML

ROLLBACK!
INITIATE D.R.P!

@bioDan Googling steps to revert... 😥

My advice is always: build as select in the first place and check result. Then replace the select. Not that I follow that rule 😂

@danzig666 that's good advice

I also got into the habit of writing queries in reverse. WHERE & LIMIT come first. Now it's second nature

In sqlserver usually I type Begin transaction before any ad-hoc update operations on prod, then I test it, if it works I type commit

Sometimes I forget the commit and lock up the database all day haha

Me too, @encore!

But, general rule... Backup, backup, backup! Before literally ANYTHING!

By the way, this post was 11hrs ago apparently - how did things turn out??

. (I wanna know the end.)

Happened to me once. I had chance that the IT guy made a backup right before I started.

I am safe guys... No-one knows....
Luckily my query was just after the cron backups that are scheduled every month....
I was hairline close to being fired for loosing one month's data...
PS-Please don't tell my lead about this, nobody knows... ^_^