Understanding and operations of MySQL database transactions, mysql database transactions

Understanding and operations of MySQL database transactions, mysql database transactions

A transaction is a series of operations performed as a single logical unit of work. These operations are submitted to the system as a whole, either executed or not executed. A transaction is an inseparable unit of work logic.

A transaction has four attributes, ACID attributes for short:

By default, MySQL runs in the automatic commit mode, that is, each SQL command runs as a small transaction.