Hi guys,
 
The following query works fine from the MySQL client:
 
    LOAD DATA INFILE 'data.txt' INTO TABLE 'db.table' FIELDS TERMINATED BY '|'
 
but fails in perl with a malformed SQL syntax error:
 
my $rows = $dbh->do(LOAD DATA INFILE 'data.txt' INTO TABLE 'db.table' FIELDS 
TERMINATED BY '|');
 
Anybody have a clue as to why this will not work?
 
tia,
mark

Reply via email to