php中的unbuffered_row,php – 加载数据infile和unbuffered查询错误

我正在尝试从文件中加载表格,并且遇到困难.下面的代码试图获取一个现有的数据库并将其复制到一个临时表,然后用.csv文件中的导入数据替换原始数据,然后在放开之前我还有更多工作要比较这两个表.临时的. (如果我以不同的方式做到这一点,欢迎提示).我收到错误：

‘SQLSTATE[HY000]: General error: 2014 Cannot execute queries while

other unbuffered queries are active. Consider using

PDOStatement::fetchAll()…’

我已尝试过类似问题的许多建议,但尚未解决.谢谢你的帮助！这是我的代码：

//database connection

$data_source = 'mysql:host=localhost;dbname=myDB';

$db_user = 'root';

$db_password = 'pass';

$conn = new PDO($data_source, $db_user, $db_password,

array(PDO::ATTR_EMULATE_PREPARES => false,

PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,

PDO::ATTR_PERSISTENT));

if ( isset($_GET['submit']) ){

$stmt = $conn->prepare("CREATE TEMPORARY TABLE mfsw_dupe AS SELECT * FROM mfsw_test");

$stmt->execute();

$stmt = $conn->prepare("TRUNCATE mfsw_test");

$stmt->execute();

$stmt = $conn->prepare("LOAD DATA LOCAL INFILE 'C:\\xampp\htdocs\assets\mfsw_test.csv' INTO TABLE mfsw_test

FIELDS TERMINATED BY ','

LINES TERMINATED BY '\n'

IGNORE 1 LINES");

$stmt->execute();

}

?>