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
⇒ Show the Current Transaction Mode in MySQL
⇐ Create a Table for Transaction Testing in MySQL
2016-10-17, 1690🔥, 0💬
Popular Posts:
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...