Help for this page

Select Code to Download


  1. or download this
    my $sql = qq{ LOAD DATA LOCAL INFILE \"$mysql_tmp_filename\"
    INTO TABLE `$tblname`
    ...
    
    my $sth = $dbh->prepare($sql);
    $sth->execute();
    
  2. or download this
    sub fix_file_4mysql {    #arguments: 1) path to file
                #returns: 1) the filename fixed for use in a mysql query
    ...
    
        return $mysql_tmp_filename;
    }