Mega Code Archive
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>