my $sql = "INSERT INTO temp_selectedTitles values ". join(", ", "(?)" x 100); my $sth = $dbh->prepare($sql); for (my $i = 0; $i <= $#books; $i+=100) { $sth->execute(@books[$i..$i+99]); }