How to start a transaction in MySQL

Preface

This article mainly introduces how to start a transaction in MySQL. You can also refer to the official documentation for related information.

https://dev.mysql.com/doc/refman/8.0/en/commit.html

Method 1

START TRANSACTION or BEGIN starts a new transaction COMMIT commits the current transaction ROLLBACK rolls back the current transaction

This is a well-known method, in which the methods of starting a transaction, start transaction and begin, are the same.

Method 2

SET autocommit = 0;

By default, autocommit = 1, which means that transactions are automatically committed.
Autommit is at the session level, which means that if autocommit is changed for the current connection, it will have no effect on other connections.
After setting autocommit, all SQL statements in this connection are in the form of transactions, such as each commit.

From the screenshot, we can see that there is a transaction in progress. Because set autocommit = 0; is set, the subsequent update operation will not modify the result, and other sessions will not be able to check it (RR level).

At this time, you need to manually execute commit.

Note that autocommit has not been changed. At this time, the autocommit value is still 0, which means that subsequent SQL statements of this session need to be committed manually.

This is the end of this article about how to start a transaction in MySQL. For more information about starting a transaction in MySQL, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!