https://arolstar52-zhtest.hf.space/index.php?action=history&feed=atom&title=Savepoint Savepoint - 版本历史 2026-07-02T21:33:28Z 在这个wiki上该页的修订历史 MediaWiki 1.43.8 https://arolstar52-zhtest.hf.space/index.php?title=Savepoint&diff=3139567&oldid=prev imported>Pseudo Classes：​加入{{Notability Unreferenced}}和{{Unreferenced}}標記 2021-12-05T11:44:05Z <p>加入{{<a href="/wiki/Template:Notability_Unreferenced" title="Template:Notability Unreferenced">Notability Unreferenced</a>}}和{{<a href="/wiki/Template:Unreferenced" title="Template:Unreferenced">Unreferenced</a>}}標記</p> <p><b>新页面</b></p><div>{{Multiple issues|<br /> {{Notability Unreferenced|time=2021-12-05T11:44:05+00:00}}<br /> {{Unreferenced|time=2021-12-05T11:44:05+00:00}}<br /> }}<br /> &#039;&#039;&#039;savepoint&#039;&#039;&#039;是在[[数据库]][[事务处理]]中实现“子事务”（subtransaction），也称为{{tsl|en|nested transaction|嵌套事务}}的方法。事务可以[[回滚 (数据管理)|回滚]]到savepoint而不影响savepoint创建前的变化。不需要放弃整个事务。 <br /> <br /> [[SQL]]语言国际标准中，&lt;code&gt;SAVEPOINT &#039;&#039;name&#039;&#039;&lt;/code&gt;语句声明一个savepoint。&lt;code&gt;ROLLBACK TO SAVEPOINT &#039;&#039;name&#039;&#039;&lt;/code&gt;语句回滚到savepoint。&lt;code&gt;RELEASE SAVEPOINT &#039;&#039;name&#039;&#039;&lt;/code&gt;将使得命名的savepoint被放弃，但不影响其他savepoint。&lt;code&gt;ROLLBACK&lt;/code&gt;或&lt;code&gt;COMMIT&lt;/code&gt;导致所有savepoint被放弃。 <br /> <br /> 支持savepoint的数据库有：[[PostgreSQL]]、[[Oracle数据库]]、[[Microsoft SQL Server]]、[[MySQL]]、[[IBM DB2|DB2]]、[[SQLite]](从3.6.8)、[[Firebird_(数据库)|Firebird]]、[[H2数据库]]、{{tsl|en|Informix}}(从11.50xC3)。<br /> <br /> {{databases}}<br /> <br /> [[Category:数据管理]]<br /> [[Category:事务处理]]</div> imported>Pseudo Classes