Important
The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.
In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.
COMMIT
On this page
The COMMIT command commits the open transaction if one exists.
Syntax
COMMIT [ WORK ] [ AND [ NO ] CHAIN ] [ [ NO ] RELEASE ]Remarks
-
[ AND [ NO ] CHAIN ]and[ [ NO ] RELEASE ]are ignored as these options are not currently supported by SingleStore. -
This command must be run on the master aggregator or a child aggregator node (see Node Requirements for SingleStore Commands.
Note that you must connect to the master aggregator when running this command on reference tables. -
If the transaction is unsuccessful or needs to be reverted, then execute the ROLLBACK command.
Example
For this example, consider the following Employee table:
|
ID |
Name |
|---|---|
|
30 |
Jimmy |
|
20 |
Rob |
|
40 |
Rick |
BEGIN;UPDATE Employee SET Name = "Jim" WHERE ID = 30;
Run the SELECT query to verify if the UPDATE is correct:
SELECT * FROM Employee;
+------+-------+
| ID | Name |
+------+-------+
| 30 | Jim |
| 20 | Rob |
| 40 | Rick |
+------+-------+Run COMMIT since the UPDATE was successful.
COMMIT;
Note: Before the user runs COMMIT or ROLLBACK, only that user can see the updates made after the BEGIN statement was run.
Last modified: