# 事务控制语句演示

__*控制事务*__
__*BEGIN*__

```10
tidb> ~!@BEGIN@!~;
tidb> INSERT INTO test.t1 VALUES(1);
tidb> INSERT INTO test.t1 VALUES(2);
tidb> SELECT * FROM test.t1;
+------+
| id   |
+------+
|    1 |
|    2 |
+------+

tidb> SELECT @@autocommit;
+--------------+
| @@autocommit |
+--------------+
|            1 |
+--------------+

tidb> ~!@ROLLBACK@!~;
tidb> SELECT * FROM test.t1;
Empty set (0.00 sec)
```
---------------------------------------------

BEGIN 语句优先于 @@autocommit 设置。