BEGIN, COMMIT, ROLLBACK
- Description
  - Syntax
  - Parameters
  - Note
- example
- keyword

BEGIN, COMMIT, ROLLBACK

Description

Syntax

1. BEGIN;
2. INSERT INTO table_name ...
3. COMMIT;

1. BEGIN [ WITH LABEL label];
2. INSERT INTO table_name ...
3. ROLLBACK;

Parameters

label: the label for this transaction, if you need to set it to a string.

Note

A transaction can only be used on insert, nor update or delete. You can check the state of this transaction by SHOW TRANSACTION WHERE LABEL = 'label'

example

Begin a transaction without a label, then commit it

1. BEGIN
2. INSERT INTO test VALUES (1, 2);
3. INSERT INTO test (c1, c2) VALUES (1, 2);
4. INSERT INTO test (c1, c2) VALUES (1, DEFAULT);
5. INSERT INTO test (c1) VALUES (1);
6. COMMIT:

All the data in the sql between begin and commit will be inserted into the table.

Begin a transaction without a label, then abort it

1. BEGIN
2. INSERT INTO test VALUES (1, 2);
3. INSERT INTO test (c1, c2) VALUES (1, 2);
4. INSERT INTO test (c1, c2) VALUES (1, DEFAULT);
5. INSERT INTO test (c1) VALUES (1);
6. ROLLBACK:

All the data in the sql between begin and rollback will be aborted, nothing will be inserted into the table.

Begin a transaction with a label, then commit it

1. BEGIN WITH LABEL test_label1
2. INSERT INTO test VALUES (1, 2);
3. INSERT INTO test (c1, c2) VALUES (1, 2);
4. INSERT INTO test (c1, c2) VALUES (1, DEFAULT);
5. INSERT INTO test (c1) VALUES (1);
6. COMMIT:

All the data in the sql between begin and commit will be inserted into the table. The label of test_label1 will be set to mark this transaction. You can check this transaction by SHOW TRANSACTION WHERE LABEL = 'test_label1'.

keyword

BEGIN, COMMIT, ROLLBACK