Auto Commit

Auto Commit determines whether or not a commit is sent to the database after executing each query.

If Auto Commit is set to "On", a commit will be sent to the database after each query is executed.

If Auto Commit is set to "Off", a commit will not be sent to the database. If the database being used supports transactions, the user is responsible for executing a commit explicitly when a commit is desired if Auto Commit is set to "Off". Also, rollbacks can be executed only if Auto Commit is set to "Off" and the database supports transactions.