How to insert 2 arrays into 2 fields in MySQL using Perl

[poolboi]

hi guys,

i dunno if this post should be in Perl or MySQL

but i'm using Perl DBI to do manupilations now in MySQL

i've got problem trying to input 2 arrays of data into 2 fields at the same time

say for example now i got

 
@array1 = [ 1 ,2 , 3];
@array2 = [4, 5, 6];
 

and i got say 2 fields User and Time

i tried using this code

foreach $user(@array1){
$sth -> $dbh ->perpare("INSERT INTO `trial` (User) VALUES ('$user')");
$sth->execute();
 
foreach $time(@array2){
$sth -> $dbh ->perpare("INSERT INTO `trial` (Time) VALUES ('$time')");
$sth->execute();
 

i got the results like:

 User    Time
1          NULL
2          NULL
3          NULL
NULL    4
NULL    5
NULL    6
 

how should i change or input my code so i can get this in the database

User      Time
1           4
2           5
3           6
 

[ronverdonk]

This is a coding problem, i.e. a Perl question and I do not think we in the MySQL forum can write the Perl code for that. So this thread is moved to the Perl forum.

moderator

[poolboi]

alright thanks
once again perl guys
i need your help once again
:)

[Atli]

I'm not a Perl person, but MySQL can insert into multiple columns and rows in one query:
For example:

INSERT INTO userTable(UserID, Time) VALUES
(1, 4), (2, 5), (3, 6);
 

Try re-writing your Perl code to take advantage of that.