SQLite 事务

事务保证原子性：BEGIN（或 BEGIN TRANSACTION）、COMMIT 提交、ROLLBACK 回滚。

Intermediate

Key PointsSQLite,事务,BEGIN,COMMIT,ROLLBACK

讲解

事务保证原子性：BEGIN（或 BEGIN TRANSACTION）、COMMIT 提交、ROLLBACK 回滚。

SQL

BEGIN;
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;
COMMIT;

事务保证原子性：BEGIN（或 BEGIN TRANSACTION）、COMMIT 提交、ROLLBACK 回滚。

SQL

BEGIN;
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;
COMMIT;