ROLLBACKΒΆ

Rolls back an open transaction in the current session.

See also:

BEGIN , COMMIT , SHOW TRANSACTIONS , DESCRIBE TRANSACTION

SyntaxΒΆ

ROLLBACK [ WORK ]
Copy

ParametersΒΆ

WORK

Optional keyword that provides compatibility with other database systems.

ExamplesΒΆ

Begin a transaction, insert some values into a table, and then complete the transaction by rolling back the changes made in the transaction:

SELECT COUNT(*) FROM A1;

----------+
 COUNT(*) |
----------+
 0        |
----------+

BEGIN NAME T4;

SELECT CURRENT_TRANSACTION();

-----------------------+
 CURRENT_TRANSACTION() |
-----------------------+
 1432071523422         |
-----------------------+

INSERT INTO A1 VALUES (1), (2);

-------------------------+
 number of rows inserted |
-------------------------+
 2                       |
-------------------------+

ROLLBACK;

SELECT COUNT(*) FROM A1;

----------+
 COUNT(*) |
----------+
 0        |
----------+

SELECT CURRENT_TRANSACTION();

-----------------------+
 CURRENT_TRANSACTION() |
-----------------------+
 [NULL]                |
-----------------------+

SELECT LAST_TRANSACTION();

--------------------+
 LAST_TRANSACTION() |
--------------------+
 1432071523422      |
--------------------+
Copy