my $sth = $dbh->prepare(" INSERT INTO `trial` ( User, Time ) VALUES ( ?, ? ) "); foreach my $i (0..$#array1) { $sth->execute($array1[$i], $array2[$i]); }