perl 執行mysql load data infile

juming1983

$sth = $dbh->prepare ("load data infile 'd:/test/test.csv' into table account_tmp fields terminated by ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'");

$sth->execute ();

$sth->finish ();

為什麽執行就出問題,但是copy load data infile 'd:/test/test.csv' into table account_tmp fields terminated by ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'到mysql中運行是正常的

hfahe

出什么问题？有什么错误信息？

juming1983

錯誤內容大概如下:
<missing operator before ' lines terminated by '?>
<missing operator before \?>
bad name after n' at test.pl

MMMIX

原帖由 juming1983 于 2009-5-4 18:44 发表
$sth = $dbh->prepare ("load data infile 'd:/test/test.csv' into table account_tmp fields terminated by ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'");

双引号需要转义