Question

(i) If you have not executed the COMMIT command, executing which command will reverse all updates made during the current work session in MySQL?

(ii) What effect does SET AUTOCOMMIT have in transactions ?

Answer 1

(i) ROLLBACK

(ii) If AUTOCOMMIT is set to 1, each SQL statement is considered a complete transaction and committed by default when it finishes. If AUTOCOMMIT is set to 0, the subsequent series of statements acts like a transaction and no transaction is committed until an explicit COMMIT statement is issued.