Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
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
✍: 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
2007-05-11, 5005👍, 0💬
Popular Posts:
What is the purpose of finalization? The purpose of finalization is to give an unreachable object th...
What is the version information in XML? “version” tag shows which version of XML is used.
Describe in detail Basic of SAO architecture of Remoting? For these types of questions interviewer e...
How can a servlet refresh automatically if some new data has entered the database? You can use a cli...
What are the types of variables x, y, y and u defined in the following code? #define Atype int* type...