Shulou(Shulou.com)05/31 Report--

Today, I would like to share with you the four characteristics of mysql transaction related knowledge points, detailed content, clear logic, I believe most people still know too much about this knowledge, so share this article for your reference, I hope you can get something after reading this article, let's take a look at it.

Characteristics

1. Atomicity, a transaction is an irrevocable whole, either all or all are executed.

2. Consistency, a transaction can switch data from one consistent state to another.

3. Isolation, one transaction is not disturbed by other transactions, and multiple transactions are isolated from each other.

4. Persistence, once the transaction is committed, it is permanently saved locally.

Example

/ * understanding: implicit (automatic) transaction: without obvious opening and ending, it is a transaction that can be committed automatically, such as insert, update, delete explicit transaction: with obvious start and end * / use explicit transaction: ① open transaction set autocommit=0;start transaction;# can omit ② to write a set of logical sql statements Note: sql statement supports insert, update, delete to set rollback points: savepoint rollback roll call ③ end transaction commit: commit; rollback: rollback; rollback to the specified place: rollback to rollback roll call; these are all the contents of the article "what are the four characteristics of mysql transactions?" Thank you for reading! I believe you will gain a lot after reading this article. The editor will update different knowledge for you every day. If you want to learn more knowledge, please pay attention to the industry information channel.

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.