ROLLBACK
ROLLBACK
ROLLBACK 语句用于还原 TiDB 内当前事务中的所有更改，作用与 COMMIT 语句相反。
语法图
Statement:
示例
{{< copyable "sql" >}}
CREATE TABLE t1 (a int NOT NULL PRIMARY KEY);Query OK, 0 rows affected (0.12 sec){{< copyable "sql" >}}
BEGIN;Query OK, 0 rows affected (0.00 sec){{< copyable "sql" >}}
INSERT INTO t1 VALUES (1);Query OK, 1 row affected (0.00 sec){{< copyable "sql" >}}
ROLLBACK;Query OK, 0 rows affected (0.01 sec){{< copyable "sql" >}}
SELECT * FROM t1;Empty set (0.01 sec)MySQL 兼容性
ROLLBACK 语句与 MySQL 完全兼容。如有任何兼容性差异，请在 GitHub 上提交 issue。