rollback
Discards all modifications contained in a transaction commenced by a set autocommit off
command or a commit
command. If the autocommit
setting is on, then rollback
has no effect. The general syntax is as follows:
rollback;
Note - The rollback
command does not change the autocommit
setting.