http://www.perlmonks.org?node_id=519746


in reply to Problem loading txt file into mysql

After 
my $sql=qw(load data local infile 'temp.txt' into table t1 FIELDS TERM
+INATED BY ',' OPTIONALLY ENCLOSED BY """",LINES TERMINATED BY "\r");

[download]
you can write 
print $sql; exit;

[download]
bye!!

In Section Seekers of Perl Wisdom