• joemo@lemmy.sdf.org
    link
    fedilink
    arrow-up
    2
    ·
    1 year ago

    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.