Show the Current Transaction Mode in MySQL

Q

How To Find Out the Current Transaction Mode in MySQL?

✍: FYIcenter.com

A

If you are not sure about your current transaction mode, you can use the "SELECT @@AUTOCOMMIT FROM DUAL" statement to find out as shown in the following tutorial exercise:

>\mysql\bin\mysql -u dev -piyf fyi

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

mysql> SET AUTOCOMMIT = 0;
Query OK, 0 rows affected (0.03 sec)

mysql> SELECT @@AUTOCOMMIT FROM DUAL;
+--------------+
| @@AUTOCOMMIT |
+--------------+
|            0 |
+--------------+
1 row in set (0.00 sec)

mysql> SET AUTOCOMMIT = 1;
Query OK, 0 rows affected (0.00 sec)

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

 

⇒Transaction Management: Commit or Rollback in MySQL

⇒⇒MySQL Database Tutorials

2016-10-17, 239👍, 0💬

General MySQL Oracle SQL Server