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