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