@RacerX@lemm.ee to Ask Lemmy@lemmy.world • 9 months agoWhat's the worst way you ever broke production?message-square104fedilinkarrow-up1185file-text
arrow-up1185message-squareWhat's the worst way you ever broke production?@RacerX@lemm.ee to Ask Lemmy@lemmy.world • 9 months agomessage-square104fedilinkfile-text
minus-square@ilinamorato@lemmy.worldlinkfedilink24•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
SELECTstatement first, making sure it’s returning the right number of records, and then switching out theSELECTforDELETE. Hasn’t steered me wrong yet.This.