Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^2: DBI execute_array

by DamianKaelGreen (Acolyte)
on Apr 23, 2014 at 17:20 UTC ( #1083400=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    $dbh->do("CREATE TABLE IF NOT EXISTS temp_selectedTitles (title VARCHA
    +R(128), author VARCHAR(128), location VARCAR(128))");
    
    my $number_of_rows_waiting_to_commit = 0;
    ...
    my $sql = "INSERT IGNORE INTO $DT_table (title, author, location) VALU
    +ES ".join(", ", ("(?, ?, ?)") x $number_of_rows_waiting_to_commit);
    my $store_2 = $dbh->prepare($sql);
    $store_2->execute(@chunk_of_values_for_database);
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1083400]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (4)
As of 2020-08-11 04:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Which rocket would you take to Mars?










    Results (58 votes). Check out past polls.

    Notices?