MySQL Transaction - How To Switch between Autocommit-On and Autocommit-Off Modes

How To Switch between Autocommit-On and Autocommit-Off Modes

Q

How To Switch between Autocommit-On and Autocommit-Off Modes? - MySQL FAQs - Transaction Management: Commit or Rollback

✍: FYIcenter.com

A

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

2007-05-11, 4653👍, 0💬

How To End the Current Transaction
How To End the Current Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback There are several ways the current transaction can be ended implicitly or explicitly: In "Autocommit On" mode, a single-statement transaction will be ended implicitly when the execution of the statement end... 2007-05-11, 4679👍, 0💬

How To Switch between Autocommit-On and Autocommit-Off Modes
How To Switch between Autocommit-On and Autocommit-Off Modes? - MySQL FAQs - Transaction Management: Commit or Rollback 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 ... 2007-05-11, 4654👍, 0💬

How To Start a New Transaction Explicitly
How To Start a New Transaction Explicitly? - MySQL FAQs - Transaction Management: Commit or Rollback If you are confused on the implicit new transaction rules, you can always start a new transaction with the "START TRANSACTION" command to start a new transaction explicitly. "START TRANSACTION" comma... 2007-05-11, 4640👍, 0💬

How To Find Out the Current Transaction Mode
How To Find Out the Current Transaction Mode? - MySQL FAQs - Transaction Management: Commit or Rollback 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... 2007-05-11, 4623👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.