$rows_affected = $dbh->do("UPDATE your_table SET foo = foo + 1");