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

Expand|Select|Wrap|Line Numbers

  
@array1 = [ 1 ,2 , 3];

@array2 = [4, 5, 6];

and i got say 2 fields User and Time

i tried using this code

Expand|Select|Wrap|Line Numbers

 
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:

Expand|Select|Wrap|Line Numbers

  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

Expand|Select|Wrap|Line Numbers

 
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:

Expand|Select|Wrap|Line Numbers

 
INSERT INTO userTable(UserID, Time) VALUES

(1, 4), (2, 5), (3, 6);

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

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

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

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

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

Similar Perl bytes

/bytes/development

/bytes/it

/bytes/about