+1 vote
in Class 12 by kratos

What happens when Autocommit is set on?

1 Answer

+6 votes
by kratos
 
Best answer

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.

...