Rolling Back Changes
The corollary
operation to committing data to the
database is to roll it back. The DBI defines a method called
rollback()
, which can be used to roll back the
most recent uncommitted database changes.
Like commit()
, the
rollback()
method is executed against a database handle:
$dbh->rollback();
Similarly, if rollback()
is invoked while
AutoCommit
is enabled, a warning will be displayed
similar to:
rollback ineffective with AutoCommit
signifying that the database changes have already been committed.
This warning will also be displayed when
rollback()
is invoked against a database that has
no transaction support because, by definition,
AutoCommit
will be enabled.
Get Programming the Perl DBI now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.