MySQL's business

Usage of transactions

Open transaction, start transaction;

Execute SQL statement

Commit/Rollback, commit;/rollback; commit indicates OK transaction complete, rollback means undo transaction

Atomicity of a transaction: the principle that the database transaction is not re-divided, that is, either the entire transaction is complete or the transaction is revoked.

The isolation of a transaction: the operation of a transaction is not visible to other transactions.

Transactional consistency: Refers to the rules of the data that are consistent before and after a transaction.

Persistence of a transaction: When the transaction is complete, its impact should be preserved and cannot be undone.

In addition, InnoDB only supports transactions, MyISAM is not supported, so the storage engine is selected InnoDB when the table is built.

MySQL's business