Submitted 1 year ago by drekly@lemmy.world to programming@programming.dev
“UPDATE table_name SET w = $1, x = $2, y = $4 WHERE z = $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 in order of 1234.
FML.
SQL scouts credo: I will never use indexes, I will always use column names.
If it’s Microsoft SQL you should be able to replay the transaction log. But you should be doing something like daily full backups and hourly incremental or differential backups to avoid this situation in the first place.
Things like this make me glad I can only query my db.
I learned this lesson too
I‘m using DataGrip (IntelliJ) for any manual SQL tomfoolery. I have been where you are. Luckily for me, it asks for confirmation when doing any update/delete without where clause.
Also, backups are a must, for all the right reasons and for any project.
Been there, done that, I hope you have a recent backup!
SeabassDan@lemmy.world 1 year ago
Ctrl+z bro
Jk, sounds tough