in reply to
Problem loading txt file into mysql
try this,
my $sql="load data local infile 'temp.txt' into table t1 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY \"\"\"\",LINES TERMINATED BY '\r'";
-kulls
Comment on
Re: Problem loading txt file into mysql
In Section
Seekers of Perl Wisdom