"Ok, I'm getting fired for this" moment?

Week 50 Group Rant

Nojil

8y

Accidentally using a MySQL update and not specifying the where....yeah needless to say every single dB record got updated to trash data and the DB wasn't backed up....I was a brand new developer so....

undefined

wk50

Ranter

Comments

2

digitalmcgrath

599

8y

I still get nervous that I will do this so I usually write the where clause first.
2

Alfer

548

8y

Happened to me once, now i do a select first to see which data will be updated, with their old and new values

It takes time, a shitton of time
4

kurtdawg24

202

8y

That's my biggest fear when working SQL. And locking a high traffic table. Oh lawd
1

adifferent

77

8y

Been there... not funny at all. That's why I first run my scripts on dummy datasets.

Related Rants

devRant © 2021 Hexical Labs LLC
Privacy Policy | Terms of Service