Important
New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.
ROLLBACK
On this page
The ROLLBACK command rolls back the open transaction if one exists.
Syntax
ROLLBACK [ WORK ] [ AND [ NO ] CHAIN ] [ [ NO ] RELEASE ]
Remarks
-
[ AND [ NO ] CHAIN ]and[ [ NO ] RELEASE ]are ignored as these options are not currently supported by SingleStore Helios.
Example
For this example, consider the following Employee table:
|
ID |
Name |
|---|---|
|
30 |
Jim |
|
20 |
Rob |
|
40 |
Rick |
BEGIN;
UPDATE Employee SET Name = "John" WHERE ID = 300;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0Run the SELECT query to verify if the UPDATE is correct:
SELECT * FROM Employee;
+------+-------+
| ID | Name |
+------+-------+
| 30 | Jim |
| 20 | Rob |
| 40 | Rick |
+------+-------+Run ROLLBACK since there were no matching results for the ID and the UPDATE was not successful.
ROLLBACK;
Note: Before the user runs COMMIT or ROLLBACK, only that user can see the updates made after the BEGIN statement was run.
Last modified: