• 0 Posts
  • 54 Comments
Joined 1 year ago
cake
Cake day: June 14th, 2023

help-circle










  • Transactions are the safe way of doing it.

    You can also return * to see the changes, or add specific fields.

    Like for example:

    Begin; Update users Set first_name=‘John’ Where first_name=‘john’ Returning *;

    Then your Rollback; Or Commit;

    So you’d see all rows you just updated. You can get fancy and do a self join and see the original and updated data if you want. I like to run an identifying query first, so I know hey I should see 87 rows updated or whatever.

    Haven’t had any issues with table locks with this, but we use Postgres. YMMV.


  • joemo@lemmy.sdf.orgtoMemes@lemmy.mlGet out and vote!
    link
    fedilink
    arrow-up
    15
    arrow-down
    1
    ·
    1 year ago

    Your presidential elections are like the last step in the process. If you want to make real change, you need to start from the bottom up. You can’t just say (not saying you do this) “oh shit there’s a presidential election this year? And I dislike the Democrats candidate? Time to vote for a third party candidate to show them!”

    It’s kind of like baking a cake I guess. If you just jump in at the end and taste the cake, well you’re stuck with what it is. "Oh I wish this was a chocolate cake instead of vanilla. I’m not going to eat this cake. I’m going to eat this other cake ", well you should have gotten involved earlier and who knows what’s in that other cake, it could have those disgusting flavored jelly beans in it.

    I do agree that not voting leads to problems.