MySql query doesnt display all the data

Question

I have this MySql query:

SELECT `fecha`, GROUP_CONCAT(CONCAT_WS('|', `idItem`, `nombreItem`, `cantidad`) ORDER BY `fecha`) schedule
  FROM inventarioStat
 GROUP BY fecha

the thing is it doesnt display all the data in the data it should. It only displays the last 50 or so entry? Is there some kind of limit or something Im not seeing?

Can you push me in the right direction?

ToBe · Accepted Answer · 2014-01-29 12:31:01Z

4

According to this page in the manual, the result is truncated.

http://dev.mysql.com/doc/refman/5.7/en/group-by-functions.html#function_group-concat

The result is truncated to the maximum length that is given by the group_concat_max_len system variable, which has a default value of 1024. The value can be set higher, although the effective maximum length of the return value is constrained by the value of max_allowed_packet.

try to change this setting to see if this is the case:

SET [GLOBAL | SESSION] group_concat_max_len = val;

answered Jan 29, 2014 at 12:31

ToBe

2,6791 gold badge20 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Iznogud Over a year ago

Thanks for the quick answer, this is it. Any advice how should I go about it? Whats the consequences of raising the max allowed packet? Is there a way around?

ToBe Over a year ago

You could allways just select all content as individual rows and concat in your application logic.

Iznogud Over a year ago

Im sorry , but that exceeds my knowledge of mysql. What kind of query would that be?

ToBe Over a year ago

Just omit the GROUP_CONCAT, CONCAT_WS and GROUP BY clauses. Do a plain standard SELECT and do everything in your application.

Collectives™ on Stack Overflow

MySql query doesnt display all the data

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related