php - 将 LOAD DATA UNFILE MySQL UPDATE 转换为 php

Question

我写了一个 MySQL 更新语句，它从一个 csv 文件更新一个表。当从 phpMyAdmin 运行时，此命令完美运行，但当尝试从 php 运行时，它失败了。它说我的语法有错误。

这是我的 php 代码片段

$file = "/root/location/to/file.csv";
$db = IEM::getDatabase();
$recover = "CREATE TEMPORARY TABLE temptable LIKE email_list_subscribers; LOAD DATA INFILE '$file' INTO TABLE temptable FIELDS TERMINATED BY ',' (emailaddress, subscriberid, confirmed); UPDATE email_list_subscribers INNER JOIN temptable on temptable.subscriberid = email_list_subscribers.subscriberid SET email_list_subscribers.confirmed = temptable.confirmed; DROP TEMPORARY TABLE temptable;";
$result = $db->Query($recover);

关于我哪里出错有什么建议吗？

错误消息被截断为:

You have an error in your SQL syntax; check the manual that correspond...

Answer 1

感谢@spencer7593 的建议。 Query 函数不支持多个查询。因此我的回答如下:

$file = "/root/location/to/file.csv";
$db = IEM::getDatabase();
$recover = "CREATE TEMPORARY TABLE temptable LIKE email_list_subscribers;";
$result = $db->Query($recover); 
$recover ="LOAD DATA INFILE '$file' INTO TABLE temptable FIELDS TERMINATED BY ',' (emailaddress, subscriberid, confirmed);";
$result = $db->Query($recover); 
$recover = "UPDATE email_list_subscribers INNER JOIN temptable on temptable.subscriberid = email_list_subscribers.subscriberid SET email_list_subscribers.confirmed = temptable.confirmed;";
$result = $db->Query($recover);
$recover = "DROP TEMPORARY TABLE temptable;";
$result = $db->Query($recover);