Select Code to Download

my $sth = $dbh->prepare("
   UPDATE many_address
...
   chomp($street);
   $sth->execute($name,$add,$street);
}

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

...

...
   my $ret = $sth->execute($name,$add,$street);
   print "no update for $name\n" if $ret == 0;
}