$a = '
SELECT * FROM `'. $table .'` WHERE `chrDate` > "'. $lastDate .'" INTO OUTFILE "'. $file .'"
FIELDS TERMINATED BY ", " ENCLOSED BY ''"'' ESCAPED BY "'"
LINES TERMINATED BY "'n"
';
我不知道为什么我不能这样做,我尝试解决它几次,但每次我都会给出这个错误:(
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''n"' at line 2
*回声$a *
SELECT * FROM `tbl_SaleApa` WHERE `chrDate` > "2001/03/29" INTO OUTFILE "C:/xampp/htdocs/transfer/tempfile/tbl_SaleApa.sql"
FIELDS TERMINATED BY ", " ENCLOSED BY '"' ESCAPED BY "'"
LINES TERMINATED BY "'n"
我有这个:编辑:您还将变量封装在不需要的双引号中。请参阅更新的代码。
<?php
$table='myTable';
$lastDate='myDate';
$file='myFile.ext';
$a = "SELECT * FROM $table WHERE chrDate > '$lastDate' INTO OUTFILE '$file'
FIELDS TERMINATED BY ', ' ENCLOSED BY ''"' ESCAPED BY ''''
LINES TERMINATED BY '''n'";
echo $a;
?>
输出以下内容:
SELECT * FROM myTable WHERE chrDate > 'myDate' INTO OUTFILE 'myFile.ext'
FIELDS TERMINATED BY ', ' ENCLOSED BY '"' ESCAPED BY '''
LINES TERMINATED BY ''n'
$a = "SELECT * FROM " . $table . " WHERE chrDate > '" . $lastDate . "' INTO OUTFILE '" . $file . "'
FIELDS TERMINATED BY ', ' ENCLOSED BY ''"' ESCAPED BY ''''
LINES TERMINATED BY ''n'";
$sql = '
SELECT * FROM `'. $table .'` WHERE `chrDate` > "'. $lastDate .'" INTO OUTFILE "'. $file .'"
FIELDS TERMINATED BY ", " ENCLOSED BY ''"'' ESCAPED BY "''"
LINES TERMINATED BY "'n"';
我的问题解决了:
$a = '
SELECT * FROM `'. $table .'` WHERE `chrDate` > "'. $lastDate .'" INTO OUTFILE "'. $file .'"
FIELDS TERMINATED BY ", " ENCLOSED BY ''"'' ESCAPED BY "'''"
LINES TERMINATED BY "'n"
';
将ESCAPED BY "'"
更改为ESCAPED BY "'''"