MySQL study notes (14) of the business

Transaction

Transactions: ( InnoDB support only)

a set of operations that are either executed or not executed. Atomic Nature

The session is not visible until the transaction has finished executing. Isolation of

The total amount of data is still matched before and after the transaction occurs. Consistency

the impact of a transaction cannot be undone. Durability

Transaction errors do not allow revocation, only transaction ' compensation '.

Using transactions:

Start transaction;

SQL1,

SQL2,

SQL3,

.........

[Commit ( submit )/rollback ( revocation )]

Note: There are some statements that cause the transaction to be committed implicitly.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/75/A3/wKiom1Y_Q6jx5ZJ2AAA96CzQixw774.png "title=" Picture 3.png "alt=" Wkiom1y_q6jx5zj2aaa96czqixw774.png "/>

This article is from the "Learning and Exchange" blog, please be sure to keep this source http://chenhaolinux.blog.51cto.com/9609922/1710813

MySQL study notes (14) of the business