Outdated Version
You are viewing an older version of this section. View current production version.
COMMIT
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 MemSQL.- This command must be run on the master aggregator or a child aggregator node (see Node Requirements for MemSQL Commands.
- 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.
