ROLLBACK

version 11

ROLLBACK [TRANSACTION]

The ROLLBACK command cancels the transaction underway and restores the data to its previous state at the beginning of the transaction. It also frees up any resources held by the transaction. The TRANSACTION keyword is optional.

This example illustrates the use of the ROLLBACK command:

   START TRANSACTION
   SELECT * FROM suppliers
   WHERE supplier_name like '%bob%';
   ROLLBACK TRANSACTION;

COMMIT.