php - mysql导出csv时出错

Question

新手，我创建了以下查询来从数据库中选择并导出为 csv，但我不断收到错误:

$query = "SELECT firstname,lastname,phone,email WHERE firstname = 'Trenton' INTO OUTFILE 'C:/tjtest2.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n' FROM students";
$result = mysql_query($query) or die('error'); 
if($result)
{
    echo"yes!";
}
else
{
    echo"NO!";
};

我可怕的芯片错误不断出现，但我不知道问题出在哪里

Answer 1

您需要在条件之前从学生那里使用

$query = "SELECT firstname,lastname,phone,email form students WHERE firstname = 'Trenton' INTO OUTFILE 'C:/tjtest2.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'";