minus-squarefiveoar@lemmy.dbzer0.comtoProgramming@programming.dev•I accidentally removed the WHERE clause from my SQL query in a personal tool. Every row is now the same. I overwrote 206,000+ rows. I have no backup, I am stupid.linkfedilinkarrow-up9·1 year agoI have done this too. Shit happens. One of my co-workers used to write UPDATE statements backwards limit then where etc, to prevent this stuff, feels like a bit of a faff to me. linkfedilink
minus-squarefiveoar@lemmy.dbzer0.comtoProgrammer Humor@programming.dev•Planning is for the weaklinkfedilinkarrow-up0·1 year agoDeployments and deployment frequency pretty squarely a developer’s responsibility… linkfedilink
I have done this too. Shit happens.
One of my co-workers used to write
UPDATE
statements backwards limit then where etc, to prevent this stuff, feels like a bit of a faff to me.