MySQL provides the @@autocommit system variable that allows you to view the current autocommit mode setting. : autocommit « Transaction « SQL / MySQL






  1. SQL / MySQL
  2. Transaction
  3. autocommit

MySQL provides the @@autocommit system variable that allows you to view the current autocommit mode setting.

     
mysql>
mysql> SELECT @@autocommit;
+--------------+
| @@autocommit |
+--------------+
|            1 |
+--------------+
1 row in set (0.00 sec)

mysql>








Related examples in the same category

1.The following SET statement sets the autocommit mode to off:
2.Statements That Automatically Commit Transactions
3.Turn the autocommit mode back on