Turn the autocommit mode back on : autocommit « Transaction « SQL / MySQL






  1. SQL / MySQL
  2. Transaction
  3. autocommit

Turn the autocommit mode back on

      

SET AUTOCOMMIT=1;

Related examples in the same category

1.MySQL provides the @@autocommit system variable that allows you to view the current autocommit mode setting.
2.The following SET statement sets the autocommit mode to off:
3.Statements That Automatically Commit Transactions