标题: perl 執行mysql load data infile [打印本页] 作者: juming1983 时间: 2009-05-04 18:40 标题: perl 執行mysql load data infile $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 时间: 2009-05-04 22:22
$sth = $dbh->prepare ("load data infile 'd:/test/test.csv' into table account_tmp fields terminated by ',' ENCLOSED BY '\"' LINES TERMINATED BY '\r\n'");