How to start transactions in Mysql data table

This article mainly introduces to you How to open transactions in the mysql data table.

Mysql transaction is the smallest indivisible unit of work. Usually a transaction corresponds to a complete business, and there are two methods for processing transactions. Simply put, they are manual transactions and automatic transactions. Regarding the definition and basic knowledge of mysql transactions, I have already introduced it to you in the previous article. Friends who need it can refer to it first.

【What does transaction mean in mysql data table】

Then the opening of manual transaction, as the name implies, requires us to actively open or close it ourselves.

How to open a transaction in mysql?

Below we will introduce in detail mysql manual transaction opening with a simple example.

First we connect to the database test and query the money table. The data in the table is as follows:

As shown in the money data table, there are two pieces of data. Here we can assume that the people with id 1 and 2 have 2000 and 2000 respectively. 3000 salary.

Then we start the transaction through the sql statement that opens the transaction.

The basic syntax for opening a transaction is as follows:

start transaction;

Then perform some update operations on the data. For example, the person with ID 1 lends 1,000 yuan to the person with ID 2, then the specific operation process is as follows: The query results are shown in the figure below.

Finally, we can check whether the data in the data table has changed through Navicat. The result is as shown in the figure below:

As you can see from the picture, the actual data in the money table has not changed at all! This is because , when we start a transaction and then perform a series of data updates and other operations, the updated data will not be written directly to the database, but will exist in our transaction log. We only have to The real data in the database will be changed only when the transaction is committed or rolled back. Then in the later articles, we will continue to explain the relevant knowledge of transaction submission and rollback. You can continue to pay attention to the latest courses on the PHP Chinese website.
This article is an introduction to the relevant knowledge about manual transaction opening of mysql data table. It is simple and easy to understand. I hope it will be helpful to friends in need!

If you want to know more about mysql, you can follow the PHP Chinese website

, everyone is welcome to refer to and learn!

The above is the detailed content of How to start transactions in Mysql data table. For more information, please follow other related articles on the PHP Chinese website!