CODEWITHSUNDEEP
mysql
KubiRoazhon
KubiRoazhon

Reputation: 1839

How to display the whole column value with GROUP_CONCAT in MySQL

I have a MySQL query that should display me 3 columns in result id, group_id and url. I'm using the GROUP_CONCAT function in order to get some concatenated urls. My problem is the GROUP_CONCAT case is truncated, I can't see the whole result. Here's the query result

ID | GROUP_ID | URLS
1      4        http://www.stackoverflow.....

So any help please to show the whole case value. Thanks

Upvotes: 0

Views: 124

Answers (1)

Alex Tartan
Alex Tartan

Reputation: 6836

You could use this before running that SELECT:

SET SESSION group_concat_max_len = 1000000;

Or in mysql.conf to make it permanent (restart service to take effect):

[mysqld]
group_concat_max_len=1000000

But that's just covering up a bigger issue.
That limit has a reason. By default it is 1024.
Perhaps look into changing the way you store that data.

For more details, check the mysql docs.

Upvotes: 2

Related Questions