MySQL - Show the Current Transaction Mode in MySQL

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, 715👍, 0💬

Create a Table for Transaction Testing in MySQL
How To Create a Table for Transaction Testing in MySQL? If you want to learn transaction management, you should create a table with the InnoDB storage engine. The default storage engine MyISAM does not support the transaction concept. The tutorial exercise below shows you a good example of creating ... 2016-10-17, 794👍, 0💬

Commit the Current Transaction in MySQL
How To Commit the Current Transaction in MySQL? If you have used some DML statements updated some data objects, and you want to have the updates to be permanently recorded in the database, you can use the COMMIT command. It will make all the database changes made in the current transaction become pe... 2016-10-17, 737👍, 0💬

Start a New Transaction Explicitly in MySQL
How To Start a New Transaction Explicitly in MySQL? If you are confused on the implicit new transaction rules, you can always start a new transaction with the "START TRANSACTION" command to start a new transaction explicitly. "START TRANSACTION" command works in both "Autocommit On" and "Autocommit ... 2016-10-17, 725👍, 0💬

Show the Current Transaction Mode in MySQL
How To Find Out the Current Transaction Mode in MySQL? 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 @@AUTOCOMM... 2016-10-17, 716👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.