Search results
InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ROLLBACK. The SAVEPOINT statement sets a named transaction savepoint with a name of identifier. If the current transaction has a savepoint with the same name, the old savepoint is deleted and a new one is set.
Jan 16, 2019 · mysql > START TRANSACTION; Query OK, 0 rows affected (0.00 sec) Establish a SAVEPOINT named ‘initial_save’: 1. 2. mysql > SAVEPOINT initial_save; Query OK, 0 rows affected (0.00 sec) Then perform an UPDATE on a row in the table: 1.
Let us understand Partial Rollback with examples. First, execute the following SQL statements. The following SQL statement will create a transaction with three save points. Now, execute the following rollback statement which should roll back four records i.e. the INSERT statements starting from the second save point.
SAVEPOINT command is used to temporarily save a transaction so that you can rollback to that point whenever required. Following is savepoint command's syntax, SAVEPOINT savepoint_name; In short, using this command we can name the different states of our data in any table and then rollback to that state using the ROLLBACK command whenever required.
First, execute the following SQL statements. The following SQL statement will create a transaction with three save points. Now, execute the following rollback statement which should roll back four records i.e. the INSERT statements starting from the second save point. ROLLBACK TO SavePoint2;
Purpose. Use the SAVEPOINT statement to create a name for a system change number (SCN), to which you can later roll back. See Also: Oracle Database Concepts for information on savepoints. ROLLBACK for information on rolling back transactions. SET TRANSACTION for information on setting characteristics of the current transaction.
We would like to show you a description here but the site won’t allow us.
