报错:
SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
解决:
- 例1:
$rowCount = DB::connection()->getpdo()->exec(
"LOAD DATA INFILE '$file' INTO TABLE $table");
- 例2:
$rowCount = DB::connection()->getpdo()->exec(
"LOAD DATA INFILE '$file' INTO TABLE $table
SET name = $name");