my $rows_affected = $sth->execute();

# Or
my $rows_affected = $dbh->do("update table....");