RacerX@lemm.ee to Ask Lemmy@lemmy.world · 1 year agoWhat's the worst way you ever broke production?message-squaremessage-square104fedilinkarrow-up1183arrow-down19file-text
arrow-up1174arrow-down1message-squareWhat's the worst way you ever broke production?RacerX@lemm.ee to Ask Lemmy@lemmy.world · 1 year agomessage-square104fedilinkfile-text
minus-squareilinamorato@lemmy.worldlinkfedilinkarrow-up23·1 year 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.
My trick is writing it as a
SELECT
statement first, making sure it’s returning the right number of records, and then switching out theSELECT
forDELETE
. Hasn’t steered me wrong yet.This.