Problem loading txt file into mysql

[Anonymous Monk]

Dear Monks,

I have a problem to uploading a text file into mysql.

The following errors is showing:

You have an error in your SQL syntax.  Check the manual that correspon
+ds to your MySQL server version for the right syntax to use near '"\r
+"' at line 1 at C:/Apache2/cgi-bin/dbi.cgi line 13.

Here is my coding for your view

#!d:\perl\bin\perl
use CGI qw(:standard);
use CGI::Carp qw(warningsToBrowser fatalsToBrowser);
use DBI;

print header;
print start_html("Results");

my $dbh=DBI->connect('DBI:mysql:test','root','') or die "Can't connect
+ $DBI::errstr";
my $sql=qw(load data local infile 'temp.txt' into table t1 FIELDS TERM
+INATED BY ',' OPTIONALLY ENCLOSED BY """",LINES TERMINATED BY "\r");
#my $sql ="insert into t1 values('kushboo', 1)";  ## ITS WORKING
my $sth=$dbh->prepare($sql) || die "$DBI::errstr";
$sth->execute || die "$DBI::errstr";
$dbh->disconnect;
print end_html;

Thanks in Advance!!

[rnahi]

qw stands for "quoted words", and it will produce a list.

When you assign the result of qw to a scalar, it will get the last element of the list.

$ perl -le '$x = qw(a b c); print $x'
c

$ perl -le '$x = q(a b c); print $x'
a b c

Replace qw() with q() and all will be well.

[spadacciniweb]

After

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

you can write

print $sql; exit;

bye!!

[Michalis]

Did you try to replace the double quotes ("") in \r with single quotes?

[kulls]

try this,