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, 1423🔥, 0💬
Popular Posts:
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...