You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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.