BEGIN;
UPDATE accounts SET balance = balance - 100.00
WHERE name = ’Alice’;
-- etc etc
COMMIT;
UPDATE accounts SET balance = balance - 100.00
WHERE name = ’Alice’;
-- etc etc
COMMIT;
BEGIN ~ COMMIT/ROLLBACK을 쓰면 된다.
아래는 SAVEPOINT라는 키워드가 나온다..
아래는 SAVEPOINT라는 키워드가 나온다..
BEGIN;
UPDATE accounts SET balance = balance - 100.00
UPDATE accounts SET balance = balance + 100.00
ROLLBACK TO my_savepoint;
UPDATE accounts SET balance = balance + 100.00
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 Wally’s 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
4. UPDATE
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. 트랜잭션 완료
![[http]](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAMAAACecocUAAAA51BMVEUPDxEQEBQPECEPFTAeGiIjIygkJCwyLSorNFI1MC5DNzBIOylQSTkQLnAeP41MUXxTapt4WiCVbxuUglGZhEVXWV1lY2VpYFxxbV15cGBtanCAblx8cWmAe3aRgHeQg3QbQ6AiT7VIcatpg7Rojbdpl8Z8kbQ7/w+bscvAdBq9cR6zcym5jxq5jyDAkSnKkR7Rmh7ZfhDiiA/bmxfimBupko7/cA/vlBD6mw/bpSTbsSDHnjbpqxHvqRflshfotBn8rQ//nw/7wA//yw//pw//ww//0Q//0g//2A+vs7jV1N692frV6P/+fUWVAAAAKHRSTlP///////////////////////////////////////////////////8AvqouGAAAAAFiS0dETPdvEPMAAABySURBVHjaY1BXV5eTVZEHUuoM6uqepmr8xjpgto+XtKahkasQkK3hLWygreXgYi6mzqBqbS9jaeJoZsGuzqBk4+xkpS+ly8WtzqAsYOdhK6HIwSIO1Ksg4qbHx8vMADaTx12Qk4kRYr66JBurKNQuOAAA/ZkSIzXnQk8AAAAASUVORK5CYII=)
![[https]](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAMAAACecocUAAAAB3RJTUUH1AgVDAQv1GsZzAAAAAlwSFlzAAALEgAACxIB0t1+/AAAAwBQTFRFSEhKSUlLSElVSExgU1BWV1daV1ddYV5bXGN4Y2BfbmVgcWdbd3JnSV+OU2ujdHiXeYqtlH5UqY1RqJt4rJ1vfH2AhoSGiYOAj4yAlY6DjIqOmYyAl4+JmZaSppmTpZyRUW6xVnbAcY+5iZy/iKPCiarMl6a/Z+dIrb3QyJFQxo9TvpBbw6VQw6VUyKZbz6ZT1K1T2plJ4KBI261O4KtRt6ek545I56hJ561I27VX271Uza9k5rlK57dO4r5O5b9P57pI57BI58hI59BI57VI58pI59RI59VI59lIvL7C19bextrn1+XnSEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhIs0TWLQAAACh0Uk5T////////////////////////////////////////////////////AL6qLhgAAABySURBVHjaY1BXV5eTVZEHUuoM6uqepmr8xjpgto+XtKahkasQkK3hLWygreXgYi6mzqBqbS9jaeJoZsGuzqBk4+xkpS+ly8WtzqAsYOdhK6HIwSIO1Ksg4qbHx8vMADaTx12Qk4kRYr66JBurKNQuOAAA/ZkSIzXnQk8AAAAASUVORK5CYII=)
