364
submitted 1 year ago* (last edited 1 year ago) by drekly@lemmy.world to c/programming@programming.dev

"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.

you are viewing a single comment's thread
view the rest of the comments
[-] AlphaOmega@lemmy.world 109 points 1 year ago* (last edited 1 year ago)

This is a hard lesson to learn. From now on, my guess is you will have dozens of backups.

[-] marcos@lemmy.world 64 points 1 year ago

And a development environment. And not touch production without running the exact code at least once and being well slept.

[-] snail_hatan@lemmy.ml 9 points 1 year ago

Fuck that, get shit housed and still do it right. That's a pro.

[-] spartanatreyu@programming.dev 19 points 1 year ago

That's not pro, that's just reckless gambling.

[-] snail_hatan@lemmy.ml 4 points 1 year ago

Totally right! You must set yourself up so a fool can run in prod and produce the expected result. Which is the purpose of a test env.

load more comments (1 replies)
load more comments (1 replies)
load more comments (8 replies)
this post was submitted on 11 Oct 2023
364 points (97.6% liked)

Programming

17314 readers
221 users here now

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev



founded 2 years ago
MODERATORS