On this page
Commits any existing open transaction on the current connection and starts a new transaction.
START TRANSACTION | BEGIN [WORK]
This command must be run on the master aggregator or a child aggregator node (see Node Requirements for SingleStoreDB Commands.
Note that you must connect to the master aggregator when running this command on reference tables.
If the transaction is successful, execute the COMMIT command to commit the changes; if the transaction is unsuccessful or needs to be reverted, then execute the ROLLBACK command to revert the changes.
The maximum number of tables that can be written into a single transaction is 1024.
If the transaction table writes exceed the maximum amount, an error will be generated. Execute the
ROLLBACKcommand to revert any changes.
Then split the transaction into smaller sections and execute again.
For this example, consider the following
UPDATE Employee SET Name = "John" WHERE ID = 300;
Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0
SELECT query to verify if the
UPDATE is correct:
SELECT * FROM Employee;
+------+-------+ | ID | Name | +------+-------+ | 30 | Jim | | 20 | Rob | | 40 | Rick | +------+-------+
ROLLBACK since there were no matching results for the
ID and the
UPDATE was not successful.
Note: Before the user runs
ROLLBACK, only that user can see the updates made after
BEGIN was run.
Last modified: June 22, 2022