What is the rollback point of manual transactions in Mysql data table

This article mainly introduces to you What is the rollback point of manual transactions in mysql data table.

First of all, everyone needs to know what transactions are in mysql?

A transaction refers to something to be done or done. In computer language, it refers to a program unit that accesses and may update various data items in the database. It is also a logical work in the operation of the database. Unit, the transaction management subsystem in the DBMS is responsible for transaction processing.

In fact, in the previous article, I have given you a detailed introduction to the specific definition of mysql transactions. Friends who need to know more can refer to this article [What does transaction mean in mysql data table] .

The main content of this section is to introduce in detailWhat is the rollback point of mysql manual transaction.

Transaction rollback can be understood as the end of failure, which is to clear all DML (insert, update, delete) statement operation history records.

The so-called rollback of a transaction simply means that when a problem occurs in a certain operation of a transaction, the entire transaction can be rolled back as if no operation has been performed. In other words, when an error occurs or the transaction is cancelled, Then roll back the transaction.

Transaction rollback and rollback point are not exactly the same concepts.

We all know that when a transaction is started, all operations will be stored in the transaction log, and only when we commit the transaction will our updated data be synchronized to the data table.

So what exactly is a rollback point?

We can introduce it to you based on some examples from daily life.

For example, when we were shopping on Taobao, after we selected the products and were about to choose the payment method, we accidentally chose the wrong one. At this time, you need to return to the payment method selection page, so the point where you want to perform the return operation will be set as Rollback point. When we make a wrong choice, the return operation is the operation of returning to the rollback point.

Related syntax for rollback point:

Set the rollback point:

savepoint + 回滚点名称;

Return to the rollback point:

rollback to + 回滚点名称;

This article The article is an introduction to the basic knowledge about mysql manual transaction rollback points, and it is also very easy to understand. In later articles, we will continue to introduce the specific usage of rollback points, as needed Friends can follow!

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 What is the rollback point of manual transactions in Mysql data table. For more information, please follow other related articles on the PHP Chinese website!