Butt Pirate
link
fedilink
411Y

BEGIN

UPDATE

SELECT

COMMIT

@342345@feddit.de
link
fedilink
5
edit-2
1Y

Why update before select? Shouldn’t it be the other way around? (I’m clueless. )

Juja
link
fedilink
91Y

The select after the update is to check if the update went through properly. You can have more selects before the update if you wanted to.

Ah. It makes sense now. Thanks.

And you can save a bunch of time by inlining all this into one query

The four horsemen of the datapocalypse

Be Safe! Be a BUSCer!

Create a post

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

  • Posts must be relevant to programming, programmers, or computer science.
  • No NSFW content.
  • Jokes must be in good taste. No hate speech, bigotry, etc.
  • 1 user online
  • 18 users / day
  • 117 users / week
  • 455 users / month
  • 2.2K users / 6 months
  • 1 subscriber
  • 1.69K Posts
  • 37.2K Comments
  • Modlog