嘪䫘 ROLLBACK TO SAVEPOINT 啂悔彄婔婻媺庻䗹㔗嘪䫘 RELEASE SAVEPOINT 役鍴婔婻媺庻䗹嘖滇媺䘍臖媺庻䗹傺䆋劯欓臯䔇变傴䔇昽悩㔗
媺庻䗹埻脘婘婔婻庋媇庖麯麵傺䆋㔗婘婔婻庋媇麯麵埇傖垔幬崔婻媺庻䗹㔗
傺䆋婔婻媺庻䗹䘉劯搴體認婻媺庻䗹傺䆋劯欓臯䔇欔橬变傴䔇䂷悩
BEGIN; INSERT INTO table1 VALUES (1); SAVEPOINT my_savepoint; INSERT INTO table1 VALUES (2); ROLLBACK TO SAVEPOINT my_savepoint; INSERT INTO table1 VALUES (3); COMMIT;
婪麵䔇庋媇儖某噖昄唚 1 启 3 蔯婉嚔某噖 2 㔗
傺䆋幽䘉劯役鍴婔婻媺庻䗹
BEGIN; INSERT INTO table1 VALUES (3); SAVEPOINT my_savepoint; INSERT INTO table1 VALUES (4); RELEASE SAVEPOINT my_savepoint; COMMIT;
婪麵䔇庋媇儖某噖 3 启 4 㔗