Transaction processing of MYSQL there are two main methods of.

Recommended for you: Get network issues from WhatsUp Gold. Not end users.
Transaction processing of MYSQL there are two main methods of.
1, Using begin, rollback, commit to achieve
Begin starts a transaction
The rollback transaction rollback
The commit transaction confirmation
2, Autocommit mode directly with set to change MySQL
MYSQL is automatically submitted by default, that you submit a QUERY, it can directly execute! We can through the
Set autocommit=0 disable automatic submission
Set autocommit=1 opens automatically submit

Processing to achieve affairs.

Be careful:
When you use set autocommit=0, you will all SQL will do for transaction processing, until you confirm with commit or rollback end, pay attention to when you end the transaction also opened a new transaction! According to the first approach only the current as a transaction!
Personal recommendation to use the first method!

Support for transaction processing only the INNODB and BDB types of data to table MYSQL! The other type is not supported! (remember!)

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Jared at December 12, 2013 - 2:42 PM