_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
FrontPage › PostgreSQL碁
|
|
BEGIN;
UPDATE accounts SET balance = balance - 100.00 WHERE name = Alice; -- etc etc COMMIT; BEGIN ~ COMMIT/ROLLBACK 磯 .
SAVEPOINT朱 れ螳 .. BEGIN;
UPDATE accounts SET balance = balance - 100.00
WHERE name = Alice;
SAVEPOINT my_savepoint;UPDATE accounts SET balance = balance + 100.00
WHERE name = Bob;
-- oops ... forget that and use Wallys accountROLLBACK TO my_savepoint; UPDATE accounts SET balance = balance + 100.00
WHERE name = Wally;
COMMIT; 碁 豌襴螻殊 る覃 れ螻 螳.
1. 碁
2. UPDATE
UPDATE accounts SET balance = balance - 100.00
WHERE name = Alice;
3. SAVEPOINT my_savepoint : 碁 讌蠍蟾讌 4. UPDATE UPDATE accounts SET balance = balance + 100.00
WHERE name = Bob;
5. れ 覦6. ROLLBACK TO my_savepoint : ル SAVEPOINT襦 覲糾
7. UPDATE
UPDATE accounts SET balance = balance + 100.00
WHERE name = Wally;
8. 碁 襭
鏤
|
觜 蟆襷 殊 . 企 殊 蠏碁る 蟆 磯 蠏碁Μ 襷 蟆 讌 . 讌襷 企至 覃 蠏瑚 れ 覦襯願 螳襯 磯 るジ 磯瑚 伎 . (觜 襦) |