php - 将 MySQL 下载为 CSV 文件时出现问题

Question

我在将 mysql 数据库输出到 csv 文件并下载它时遇到问题。下面的代码在下面的第 3 行产生错误 "unexpected T_CONSTANT_ENCAPSED_STRING"。我在第 3 行和第 4 行尝试过使用分号和不使用分号。

$FileName = "/googleresearch" .  abs(rand(0,1000000000000))  .  ".csv";

$query = "SELECT * FROM happyturtle INTO OUTFILE $FileName;
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';
LINES TERMINATED BY '\n'";

$result = mysql_query($query) or die(mysql_error());

exit;

Answer 1

您需要在第四行转义您的 "，例如:

FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"';