▲ 357 ▼ 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. (lemmy.world) submitted 2 years ago* by drekly@lemmy.world to c/programming@programming.dev 114 comments fedilink hide all child comments "UPDATE table_name SET w = $1, x = $2, z = $4 WHERE y = $3 RETURNING *", does not do the same as "UPDATE table_name SET w = $1, x = $2, y = $3, z = $4 RETURNING *", It's 2 am and my mind blanked out the WHERE, and just wanted the numbers neatly in order of 1234. idiot. FML.
[–] lakemalcom10@lemm.ee 6 points 2 years ago You might enjoy https://github.com/max-sixty/prql permalink fedilink source parent