The following SET statement sets the autocommit mode to off: : autocommit « Transaction « SQL / MySQL






  1. SQL / MySQL
  2. Transaction
  3. autocommit

The following SET statement sets the autocommit mode to off:

      

SET AUTOCOMMIT=0;

Related examples in the same category

1.MySQL provides the @@autocommit system variable that allows you to view the current autocommit mode setting.
2.Statements That Automatically Commit Transactions
3.Turn the autocommit mode back on