PDO效果很好

Question

I have a problem with PDO returns incomplete result. Specific query executed in phpmyadmin returns 6000 rows. Same query executed by PDO returns only first 1160 rows. Seems like some kind of limitation or something. This setting

$pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false); 

did not help.

Thx for answer

Edit

SELECT 
T1.`column1`,
MONTH( FROM_UNIXTIME( T1.`column2` ) ) AS month,
YEAR( FROM_UNIXTIME( T1.`column2` ) ) AS year, 
(SELECT CONCAT(T2.`column1`,';',T2.`column2`,';',T3.`column1`) FROM `table2` T2 WHERE     
T2.`column8` = T1.`column8` AND T2.`column1` LIKE '%new%') AS news,
(SELECT CONCAT(T2.`column1`,';',T2.`column2`,';',T3.`column1`) FROM `table2` T2 WHERE    
T2.`column8` = T1.`column8` AND T2.`column1` LIKE '%old%') AS oldies,
FROM table1 T1
LEFT JOIN table3 T3 ON T1.column9 = T3.column2
WHERE T1.`column2` > 1388534400

It will be one-time execution so optimalization not needed

Answer 1

Try increasing your max_input_vars to 10000 in your php.ini and see if anything changes.

At the moment it is 1000 i guess and may you run into memory errors.