-- 开始事务
BEGIN;
-- 或
START TRANSACTION;

-- 执行操作
INSERT INTO accounts (user_id, balance) VALUES (1, 1000);
UPDATE accounts SET balance = balance - 100 WHERE user_id = 1;
UPDATE accounts SET balance = balance + 100 WHERE user_id = 2;

-- 提交事务
COMMIT;

-- 回滚事务
ROLLBACK;

-- 设置事务特性
BEGIN ISOLATION LEVEL SERIALIZABLE;
BEGIN READ ONLY;
BEGIN ISOLATION LEVEL READ COMMITTED READ WRITE;

-- 保存点（Savepoint）
BEGIN;
INSERT INTO users (name) VALUES ('Alice');
SAVEPOINT sp1;
INSERT INTO users (name) VALUES ('Bob');
-- 发现错误，回滚到保存点
ROLLBACK TO SAVEPOINT sp1;
-- Bob 的插入被回滚，Alice 保留
INSERT INTO users (name) VALUES ('Charlie');
COMMIT;

-- 释放保存点
RELEASE SAVEPOINT sp1;