如何从mysql到php检索大数据? [英] How to retrieve large data from mysql to php?

问题描述

如何从mysql到php检索大数据?我已经尝试过，但是得到的是 1048576 字符串，并且我的行比这大.

How can I retrieve large data from mysql to php? I've tried, but I'm getting a 1048576 characters string and my row is bigger than that.

推荐答案

好，感谢PabloJiménez，那很快.

Ok, so thanks to Pablo Jiménez, that was quick.

Pdo的缓冲区确实太小了，这样做我能够检索我的数据.

Pdo's buffer was indeed too small, by doing so i was able to retrieve my data.

$pdo = new PDO(
$dsn,
$username,
$password,
array(PDO::MYSQL_ATTR_MAX_BUFFER_SIZE => 2097152)

);

这篇关于如何从mysql到php检索大数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！