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中運行是正常的

Coolriver

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