How to set the rollback point for manual transactions in mysql data table

This article mainly introduces to you the specific use of manual transaction rollback points in mysql data tables.

The basic definition of transaction rollback point has been introduced in detail in [What is the rollback point of manual transactions in Mysql data table]. I believe you are familiar with mysql data. Have a certain understanding of the transaction rollback points in the table.

Below we will combine some simple examples to explain to you the specific settings and usage of transaction rollback points.

Suppose there is a data table money with two pieces of data. As shown in the figure below, we query the specific data through the command line tool.

And Open the transaction,The statement to open the transaction is

start transaction;

Then we do some Data update operation, for example, here we pay a salary of 10,000 yuan to the person with ID 1. Then obviously her amount is increased by 10,000, as shown in the picture below.

#Then we set a rollback point mj here.

Note, the syntax for setting the rollback point:

savepoint + 回滚点名称;

After setting the rollback point, if we originally I was going to deduct tax from the person with ID 1, but mistakenly deducted tax from the person with ID 2. As shown in the picture above, the amounts 1 and 2 have changed.

At this point, the role of the rollback point becomes apparent. Here we can perform the operation of returning to the rollback point.

Return to the rollback point syntax:

rollback to+ 回滚点名称；

As shown above, we re-deduct the tax for the person with id 1, The results are all back to normal, and the previous misoperations have not been affected at all. In other words, setting the rollback point allows us to re-operate the wrong execution statements, and the previous wrong execution statements will not take effect. !

Here we can see the importance of setting the transaction rollback point.

This article is about the setting and usage of manual transaction rollback points in

mysql data tables. It is very simple and easy to understand, so you can also test it locally.
If you want to know more about mysql, you can follow the PHP Chinese website

mysql video tutorial

, everyone is welcome to refer to and learn!

The above is the detailed content of How to set the rollback point for manual transactions in mysql data table. For more information, please follow other related articles on the PHP Chinese website!