Collections:
Show the Current Transaction Mode in MySQL
How To Find Out the Current Transaction Mode in MySQL?
✍: FYIcenter.com
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)
⇒ Start a New Transaction Explicitly in MySQL
⇐ Turn on and off Autocommit in MySQL
2016-10-17, 1416🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...