Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^3: Perl DBI to MySQL LOAD_FILE

by 1nickt (Canon)
on Jan 05, 2017 at 02:17 UTC ( [id://1178974]=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    $sql = "UPDATE artists SET page=LOAD_FILE('$infile') where code='$code
    +';";
    
  2. or download this
    my $sth = $dbh->prepare('UPDATE artists SET page=LOAD_FILE(?) WHERE co
    +de=?');
    
    for my $code ( keys %hash ) {
        $sth->execute( $hash{$code}, $code );
    }
    

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (5)
As of 2024-03-29 14:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found