MySQL Advanced affairs

Colloquial business : refers to a set of operations that are either executed successfully or not executed .----> atomicity

Other sessions are not able to see the process of intermediate changes until all operations have been completed-- isolation

The total amount of data is still matched -----> consistency before and after the transaction occurs

The impact of a transaction cannot be undone ------> Persistence

If an error is made , the transaction is not allowed to be undone, only through the " compensatory transaction "

Transfer

Lie triple :---> expenditure , lie triple -500

Zhao four :----> received , Zhao four +500

About the engine of the transaction :

Choose innodb/bdb

Open transaction : start transaction;

Sql....

Sql....

Commit Commit

rollback Rollback

Note : when a transaction commits, or the rollback ends

Note : There are some statements that cause implicit commit of transactions , such as start transaction

A specific example of a transaction:

MySQL Advanced affairs