Commit instead of rollback? [closed]

Question

Simple example (PSEUDO CODE):

for (int i = 0; i < 100; i++) { START TRANSACTION; SELECT id, name FROM employees WHERE id = i; IF (someFunction(id)) { ROLLBACK; CONTINUE; // GO TO NEXT EXECUTION OF FOR LOOP } UPDATE company SET good = good + 1; COMMIT; } 

Can I use in this example COMMIT (so I'm gonna have two COMMIT in my script) instead of ROLLBACK?

Does it make any difference to the database if I use COMMIT instead of ROLLBACK after select?

Is there any difference between MySQL and PostgreSQL here?

Answer 1

It doesn't make any difference to use COMMIT or ROLLBACK in your loop within the if block, unless the someFunction(id) method/function has hidden effects that write to the database.

I don't think this is a matter of SQL flavor at all.