国产+高潮+在线,国产 av 仑乱内谢,www国产亚洲精品久久,51国产偷自视频区视频,成人午夜精品网站在线观看

Workerman/MySQL 執(zhí)行csv導(dǎo)入失敗

AccessDenied

使用Workerman/MySQL執(zhí)行上傳的csv文件的導(dǎo)入操作失敗

$DB->query("LOAD DATA INFILE '".$files['tmp_name']."' INTO TABLE `tuanwei` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n';",null,PDO::MYSQL_ATTR_USE_BUFFERED_QUERY);

錯(cuò)誤信息

SQL:LOAD DATA INFILE '/tmp/workerman.upload.NOavoH' INTO TABLE `tuanwei` FIELDS TERMINATED BY ',' LINES TERMINATED BY ' '; 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.

是組件不支持導(dǎo)入呢？還是需要改造一下

1972 1 0
1個(gè)回答
six

看起來是上一個(gè)sql執(zhí)行后沒有把數(shù)據(jù)從緩沖區(qū)取完，上一個(gè)sql是什么？如果是取一條數(shù)據(jù)，嘗試加入limit 1

  • 暫無評論
年代過于久遠(yuǎn)，無法發(fā)表回答
??