星空网 > 软件开发 > 数据库

CUBRID学习笔记17 事务的回滚

语法:ROLLBACK [ WORK ]

 

下面的语句会报错

ALTER TABLE code DROP s_name;

INSERT INTO code (s_name, f_name) VALUES ('D','Diamond');

 

ERROR: s_name is not defined.

回滚 修复破损的伤口

ROLLBACK WORK;

再来

ALTER TABLE code drop s_name;

INSERT INTO code (f_name) VALUES ('Diamond');

 

COMMIT WORK;

 

部分回滚

可以设置标记,使回滚到指定的标记位置

 

方法1 SAVEPOINT mark;

mark:

_ a SQL identifier

_ a host variable (starting with :)

 

方法2 

 

ROLLBACK [ WORK ] [ TO [ SAVEPOINT ] mark ] [ ; ]

mark:

_ a SQL identifier

_ a host variable (starting with :)

 

例子

首先设置两个回滚的标记 sp1 和sp2

CREATE TABLE athlete2 (name VARCHAR(40), gender CHAR(1), nation_code CHAR(3), event VARCHAR(30));

INSERT INTO athlete2(name, gender, nation_code, event)

VALUES ('Lim Kye-Sook', 'W', 'KOR', 'Hockey');

SAVEPOINT SP1;

 

SELECT * from athlete2;

INSERT INTO athlete2(name, gender, nation_code, event)

VALUES ('Lim Jin-Suk', 'M', 'KOR', 'Handball');

 

SELECT * FROM athlete2;

SAVEPOINT SP2;

 

RENAME TABLE athlete2 AS sportsman;

SELECT * FROM sportsman;

ROLLBACK WORK TO SP2;

上面的重命名表的操作将被回滚

 

 

SELECT * FROM athlete2;

DELETE FROM athlete2 WHERE name = 'Lim Jin-Suk';

SELECT * FROM athlete2;

ROLLBACK WORK TO SP2;

上面的删除也不会执行,会被回滚

 

 

SELECT * FROM athlete2;

ROLLBACK WORK TO SP1;

SELECT * FROM athlete2;

COMMIT WORK;

这个是回滚到sp1的例子

 

 

 

 

 




原标题:CUBRID学习笔记17 事务的回滚

关键词:

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

淼畅物流:https://www.goluckyvip.com/tag/38726.html
淼深物流:https://www.goluckyvip.com/tag/38727.html
淼信国际:https://www.goluckyvip.com/tag/38728.html
淼信国际物流:https://www.goluckyvip.com/tag/38729.html
卖家工具:https://www.goluckyvip.com/tag/3873.html
民航局:https://www.goluckyvip.com/tag/38730.html
皇帝的皇宫=:https://www.vstour.cn/a/363188.html
海南岛琼海市旅游景点 琼海市的旅游景点:https://www.vstour.cn/a/363189.html
相关文章
我的浏览记录
最新相关资讯
海外公司注册 | 跨境电商服务平台 | 深圳旅行社 | 东南亚物流