SAVEPOINT a不存在 [英] SAVEPOINT a does not exist

问题描述

大家好



i有以下代码

Hi all

i have the following code

savepoint a;
update t1 set n1=18 where n1=13;
rollback to savepoint a;

但由于保存点a不存在而给出错误。

请帮我解决这个问题。

but its giving error as savepoint a does not exists.
Pls help me to solve this.

推荐答案

尝试：

Try:

START TRANSACTION;
savepoint a;
update t1 set n1=18 where n1=13;
rollback to savepoint a;

也请查看以下链接，例如：





http://www.java2s.com/Code/SQL/Procedure-Function/savepointexample.htm [ ^ ]

这篇关于SAVEPOINT a不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！