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, 1425🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...