You must execute the SET AUTOCOMMIT = 0; command once at the beginning of a session and once at the end of the session if you want to use the COMMIT and ROLLBACK commands.

Question

Quizplus · Accepted Answer

The SET AUTOCOMMIT = 0; command is used to disable autocommit mode at the beginning of a session, allowing the use of COMMIT and ROLLBACK. It does not need to be executed at the end of the session.

You Must Execute the SET AUTOCOMMIT = 0; Command Once