If you fear this, you can put it into script like this: BEGIN; UPDATE... SELECT for verification ROLLBACK; And then just change ROLLBACK to COMMIT, after you'

If you fear this, you can put it into script like this: BEGIN; UPDATE... SELECT for verification ROLLBACK; And then just change ROLLBACK to COMMIT, after you're sattisfied. There's no need to do it interactively.