Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Batch Upload/Insert – Row wise with Perl DBI

by morgon (Curate)
on Sep 27, 2011 at 16:18 UTC ( #928114=note: print w/replies, xml ) Need Help??


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]); }

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://928114]
help
Chatterbox?
[Discipulus]: amitkumarj441 more atention you put asking, more attentio you got in answers
Discipulus 's hoping he needs a oneliner ;=)
VinsWorldcom takes a cookie from the platter on the sideboard.
Discipulus take his wine and hope the coockie is a 'tozzetto alle mandorle'

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (8)
As of 2017-04-26 20:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (488 votes). Check out past polls.