ROLLBACKΒΆ
Rolls back an open transaction in the current session.
- See also:
SyntaxΒΆ
ROLLBACK [ WORK ]
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 | --------------------+