ROLLBACK -- abort the current transaction
ROLLBACK [ WORK ]
ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded.
WORK
Optional key word - has no effect.
Use COMMIT to successfully terminate a transaction.
Issuing ROLLBACK when not inside a transaction does no harm.
ROLLBACK is not supported within SPL programs.
To abort all changes:
ROLLBACK;
See Also
COMMIT, ROLLBACK TO SAVEPOINT, SAVEPOINT
