RacerX@lemm.ee to Ask Lemmy@lemmy.world · 9 months agoWhat's the worst way you ever broke production?message-squaremessage-square104fedilinkarrow-up1168arrow-down111file-text
arrow-up1157arrow-down1message-squareWhat's the worst way you ever broke production?RacerX@lemm.ee to Ask Lemmy@lemmy.world · 9 months agomessage-square104fedilinkfile-text
minus-squareFudoshin ️🏳️🌈@feddit.uklinkfedilinkarrow-up8·9 months agoI always put the where clause first since a fuck up in my early 20s lost a loans company £40k of business.
minus-squareilinamorato@lemmy.worldlinkfedilinkarrow-up24·9 months agoMy trick is writing it as a SELECT statement first, making sure it’s returning the right number of records, and then switching out the SELECT for DELETE. Hasn’t steered me wrong yet.
I always put the where clause first since a fuck up in my early 20s lost a loans company £40k of business.
My trick is writing it as a
SELECTstatement first, making sure it’s returning the right number of records, and then switching out theSELECTforDELETE. Hasn’t steered me wrong yet.This.
The hero we don’t deserve.