$dbh->{AutoCommit} = 0; $sth = $dbh->prepare("UPDATE $table SET title = 'new title' WHERE key1 = ? AND key2= ?"); $sth->execute($key1, $key2); $dbh->rollback(); }