fiveoar@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.
10·
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.
It always did.