For faster navigation, this Iframe is preloading the Wikiwand page for 回滚.

回滚

此條目已列出參考文獻,但因為沒有文內引註而使來源仍然不明。 (2019年12月14日)请加上合适的文內引註来改善这篇条目

回滚(英語:rollback)是数据库技术中的操作,放弃修改,使数据库状态恢复到此前的某个时刻。这对数据完整性具有关键意义。回滚是数据库事务管理重要一環。

回滚特性通常用数据库日志英语Database log实现,但也可以用多版本并发控制实现。

级联回滚

[编辑]

级联回滚(cascading rollback)是指数据库的一个事务的失败引起多个事务随之失败,都要各自回滚。

SQL

[编辑]

SQL中, ROLLBACK是一条命令,引起从最后一次BEGIN WORKSTART TRANSACTION开始的数据改变被抛弃,数据库状态恢复到改变之前。

一条ROLLBACK语句也释放任何已存的savepoint

在大多数SQL语言实现中,ROLLBACK是特定于连接。即如果两个连接指向同一个数据库,在一个连接上的ROLLBACK并不影响另一个连接。

參考文獻

[编辑]
{{bottomLinkPreText}} {{bottomLinkText}}
回滚
Listen to this article

This browser is not supported by Wikiwand :(
Wikiwand requires a browser with modern capabilities in order to provide you with the best reading experience.
Please download and use one of the following browsers:

This article was just edited, click to reload
This article has been deleted on Wikipedia (Why?)

Back to homepage

Please click Add in the dialog above
Please click Allow in the top-left corner,
then click Install Now in the dialog
Please click Open in the download dialog,
then click Install
Please click the "Downloads" icon in the Safari toolbar, open the first download in the list,
then click Install
{{::$root.activation.text}}

Install Wikiwand

Install on Chrome Install on Firefox
Don't forget to rate us

Tell your friends about Wikiwand!

Gmail Facebook Twitter Link

Enjoying Wikiwand?

Tell your friends and spread the love:
Share on Gmail Share on Facebook Share on Twitter Share on Buffer

Our magic isn't perfect

You can help our automatic cover photo selection by reporting an unsuitable photo.

This photo is visually disturbing This photo is not a good choice

Thank you for helping!


Your input will affect cover photo selection, along with input from other users.

X

Get ready for Wikiwand 2.0 🎉! the new version arrives on September 1st! Don't want to wait?