Shulou(Shulou.com)06/01 Report--

What is a transaction in mysql? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something.

A transaction is a set of atomic SQL queries, or a separate unit of work. Either all the statements within the transaction were executed successfully or all failed.

ACID properties: atomicity (atomicity), consistency (consistency), isolation (isolation), persistence (durability)

Transaction is one of the important features that distinguish the database system from all other file systems.

A transaction is a set of atomic SQL statements, or a separate unit of work.

Transactions need to meet the following characteristics:

Atomicity (ATOMICITY), definition:

A transaction must be regarded as an indivisible minimum unit of work, and all operations in the whole transaction either commit successfully or fail. For a transaction, it is impossible to perform only part of the operations.

Consistency (CONSISTENCY), definition:

Consistency means that the database transitions from one consistency state to another, and the integrity of the database data is not compromised before and after the transaction begins.

Isolation (ISOLATION), definition:

Isolation requires that one transaction modifies the data in the database and is not visible to other transactions until the commit is completed.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.