5
Mar

[MySQL] GROUP_CONCAT() limit

Today at work i run into a limitation. Doing a GROUP_CONCAT on some categories, I saw the function didn’t return all the results. The reason was that it truncated a part of them.

GROUP_CONCAT() has a default limit of 1024 chars. You can see the current limit using:

show variables like '%group_concat%'

and it can be modified using:

set group_concat_max_len=<new limit>;

where <new limit> is numeric like 10000.

Hope this may help someone.

Popularity: 100% [?]

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Welcome to my website!
My name is George Olah and I am an entrepreneur and web developer. My favorite web domains are web development, online gaming, gamification and social shopping. If you need any work done in these fields please contact me!
Signup for the Newsletter

Twitter Updates
© Copyright 2010-2017 George Olah. All rights reserved. Proudly powered by WordPress.