ROLLBACK(7) SQL Commands ROLLBACK(7)NAME
ROLLBACK - abort the current transaction
SYNOPSIS
ROLLBACK [ WORK | TRANSACTION ]
DESCRIPTION
ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded.
PARAMETERS
WORK
TRANSACTION
Optional key words. They have no effect.
NOTES
Use COMMIT [commit(7)] to successfully terminate a transaction.
Issuing ROLLBACK when not inside a transaction does no harm, but it will provoke a warning message.
EXAMPLES
To abort all changes:
ROLLBACK;
COMPATIBILITY
The SQL standard only specifies the two forms ROLLBACK and ROLLBACK WORK. Otherwise, this command is fully conforming.
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)]
SQL - Language Statements 2010-05-14 ROLLBACK(7)
Man Page
7 More Discussions You Might Find Interesting
1. Post Here to Contact Site Administrators and Moderators
Is it possible to rollback a package in Redhat ?I don't want to delete any packages.
I have upgraded a package using rpm -Uvh & now i decided to use the old package, is it possible to revert it back to the original package ? (3 Replies)
Hello All, On my SuSE system, I have wtmp log this log file permission is 644 but every reboot the file permission rollback to 664. In the logrotate.conf and logrotate.d/wtmp files the wtmp logrotate set to 644. I would like to know, which "file" or "script" modify the wtmp log to rollback to... (7 Replies)
i created a snapshot as follow as
bash-3.00# zfs snapshot dinu/dinu1@dinusnap1
then i deleted the contents in the directory dinu1
now i want to rollback that contents from snapshot and i used
bash-3.00# zfs rollback dinu/dinu1/@dinusnap1
but i received error as follow as
cannot... (3 Replies)
I am writing a software product and hope that it will work on a variety of Linux distributions. At the moment, I am trying to create some kind of Linux version of patches/upgrades of installed software. Gathering information on available updates isn't hard, nor is installation of updates, but I... (27 Replies)
Putty release : 0.61
For saved sessions , you can configure Scrollback size just once using "Lines of Scrollback" in the 'Window' menu
For a non-saved session (an ad-hoc session ) , If you want a higer scrollback size for a putty session , you have to set the "Lines of Scrollback" manually... (4 Replies)
Hi,
Recently we have patched our server to the highest level after which our application running on that server is having an issue with ssl handshake as below between 2 hosts. same error is also generated when checked from other host.
Invalid/unknown SSL header was received from peer remote... (1 Reply)