http://www.perlmonks.org?node_id=928114


in reply to Batch Upload/Insert – Row wise with Perl DBI

$sth = $dbh->prepare(“insert into table values (?, ?, ?)”); for my $i (0..2) { # adjust the upper limit accordingly $sth->execute($array1[$i], $array2[$i], $array3[$i]); }