此查询直接在mysql:中工作
LOAD DATA LOCAL INFILE '/var/www/html/parsecsv/test.csv'
INTO TABLE test
COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"'
LINES TERMINATED BY ''n'
IGNORE 1 LINES
我需要在php脚本中使用它。我正试图逃离那些特殊的角色。但我无法让它发挥作用。这是脚本:
$query = "LOAD DATA LOCAL INFILE '/var/www/html/parsecsv/test.csv'
INTO TABLE test
COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY ''"'
ESCAPED BY ''"'
LINES TERMINATED BY '''n'
IGNORE 1 LINES";
$link = mysqli_connect("localhost", "wptest", "p@ssw0rd");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s'n", mysqli_connect_error());
exit();
}
if (!mysqli_select_db($link, 'wptest')) {
echo 'Could not select database';
exit;
}
/* Select queries return a resultset */
if ($result = mysqli_query($link, $query)) {
echo "It's working";
/* free result set */
mysqli_free_result($result);
}
下面是我经常使用的技巧:
$query = <<<QUERY
LOAD DATA LOCAL INFILE '/var/www/html/parsecsv/test.csv'
INTO TABLE test
COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"'
LINES TERMINATED BY ''n'
IGNORE 1 LINES
QUERY;