# SAVEPOINT Examples

```
tidb:4000> CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY);

tidb:4000> BEGIN;

tidb:4000> INSERT INTO t1 VALUES (1);

tidb:4000> SAVEPOINT sp1;

tidb:4000> INSERT INTO t1 VALUES (2);

tidb:4000> ROLLBACK TO SAVEPOINT sp1;)

tidb:4000> COMMIT;

tidb:4000> SELECT * FROM t1;
+---+
| a |
+---+
| 1 |
+---+
1 row in set
```


------------------------------------------------------------
Navigate to https://docs.pingcap.com/tidb/stable/sql-statement-savepoint to check a more comprehensive example.