Name
RELEASE SAVEPOINT
Synopsis
RELEASE SAVEPOINT identifier
This statement instructs the server to release a savepoint
named earlier with the SAVEPOINT
statement for the current
transaction. The statement does not commit the transaction, nor does
it roll back the transaction to the savepoint. Instead, it merely
eliminates the savepoint as a possible rollback point. See the SAVEPOINT statement for more information. Here is an
example of RELEASE SAVEPOINT
:
START TRANSACTION; LOCK TABLES orders WRITE; INSERT DATA INFILE '/tmp/customer_info.sql' INTO TABLE orders; SAVEPOINT orders_import; INSERT DATA INFILE '/tmp/customer_orders.sql' INTO TABLE orders; SAVEPOINT orders_import1; INSERT DATA INFILE '/tmp/customer_orders1.sql' INTO TABLE orders; SELECT... RELEASE SAVEPOINT orders_import1;
In this example, the database administrator imports a customer
information file and two files containing customer orders and sets up
two savepoints. After running a few SELECT
statements (not fully shown here), he decides that the results of the
second batch of orders look all right and he releases the savepoint
for that batch. He hasn’t yet decided if the first batch was imported
properly. If he decides that there was a problem, he can still roll
back all of the orders imported, but he can no longer roll back just
the second batch.
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.