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

Editor to share with you what types of transactions in mysql, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. Mysql transactions are divided into explicit transactions and implicit transactions. The default transaction is an implicit transaction, and the variable autocommit is automatically opened, committed, and rolled back during operation.

2. Explicit transactions are controlled by us to open, commit, rollback and other operations.

Example

Take a look at the current autocommit status. The default is on status mysql > show variables like 'autocommit'. +-+-+ | Variable_name | Value | +-+-+ | autocommit | ON | +-+-+ 1 row in set (0.01sec)-insert a piece of data mysql > insert into ajisun values Query OK, 1 row affected (0.00 sec) mysql > rollback;-the execution of rollback also has no effect, but you can still query the inserted data (no need for us to control commit manually) mysql > select * from ajisun +-+-+ | id | name | +-+-+ | 1 | Aggie | +-+-+ 1 row in set (0.00 sec) above are all the contents of the article "what transaction types are there in mysql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow 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.