RacerX@lemm.ee to Ask Lemmy@lemmy.world · 9 months agoWhat's the worst way you ever broke production?message-squaremessage-square104fedilinkarrow-up1180arrow-down17file-text
arrow-up1173arrow-down1message-squareWhat's the worst way you ever broke production?RacerX@lemm.ee to Ask Lemmy@lemmy.world · 9 months agomessage-square104fedilinkfile-text
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.
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.