Collections:
Turn on and off Autocommit in MySQL
How To Switch between Autocommit-On and Autocommit-Off Modes in MySQL?
✍: FYIcenter.com
By default, your connection session will be in Autocommit-On mode, where every server executable statement will start a new transaction, and end the transaction when the execution ends. Changes will be committed. So consider this mode as single-statement autocommitted transaction mode.
If you don't like the default Autocommitt-On mode, you can use the "SET AUTOCOMMIT = 0" to switch to the Autocommitt-Off mode. Of course, you can switch back the Autocommitt-On mode with the "SET AUTOCOMMIT = 0" command. The following tutorial exercise shows some good examples:
>\mysql\bin\mysql -u dev -piyf fyi mysql> -- You are in the default Autocommit-On mode now mysql> SET AUTOCOMMIT = 0; Query OK, 0 rows affected (0.03 sec) mysql> -- You are in the Autocommit-Off mode now mysql> SET AUTOCOMMIT = 0; Query OK, 0 rows affected (0.03 sec) mysql> -- You are back in the Autocommit-On mode now
2016-10-17, 857👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Oracle basic concepts? I am new to Oracle dat...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Concatenate Two Text Values in Oracle? There are two ways to concatenate two text values toge...
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...
What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN in SQL Server? Process mscorsvw.exe i...