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-up10·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
I have done this too. Shit happens.
One of my co-workers used to write
UPDATEstatements backwards limit then where etc, to prevent this stuff, feels like a bit of a faff to me.