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)
2016-10-17, 715👍, 0💬
Popular Posts:
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Display a Past Time in Days, Hours and Minutes in MySQL? You have seen a lots of Websites are...