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, 3287🔥, 0💬
Popular Posts:
How to detect the collation coercibility associated to a given character string using the COERCIBILI...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How to format a number of bytes in a human-readable unit using the FORMAT_BYTES() function? FORMAT_B...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...