my $sth = $dbh->prepare($statement);
$sth->bind_param(1, undef, SQL_INTEGER); # bind undef.

for (1..$n) {
    #no need to rebind.
    $sth->execute($value);
}