My first SQL query broke the entire production database on a Friday

I was learning joins at 4pm and accidentally dropped a customer table instead of my test one. Had to call my senior dev in a panic while 50 users were locked out - how do you guys practice safely without risking real data?

3 comments

3 Comments

the_cameron29d agoTop Commenter

Read that using a local copy of your database is the only way to avoid this.

dixon.spencer1d ago

Yeah running queries blind on prod is a fast way to wreck your whole day.

brian_rivera5928d ago

Read that using a local copy" yeah, I also read that you shouldn't learn joins on production but here we are lol.