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 ).