1. Home
2. Questions
3. AI Assist Labs
4. Tags
6. Challenges
7. Chat
8. Articles
9. Users
11. Jobs
12. Companies
13. Collectives
14. Communities for your favorite technologies. Explore all Collectives
Stack Internal

Stack Overflow for Teams is now called Stack Internal. Bring the best of human thought and AI automation together at your work.
Try for free Learn more
Stack Internal
Bring the best of human thought and AI automation together at your work. Learn more

Return to Answer

format code

edited Jan 2, 2020 at 14:46

9.1k
115
69
81

If you have a large amount of data for the GROUP_CONCAT example above, you may need to change your group_concat_max_len to avoid a syntax error due to truncation. SET SESSION group_concat_max_len=4096; See

SET SESSION group_concat_max_len=4096;

See: Trouble with GROUP_CONCAT and Longtext in MySQL

If you have a large amount of data for the GROUP_CONCAT example above, you may need to change your group_concat_max_len to avoid a syntax error due to truncation. SET SESSION group_concat_max_len=4096; See: Trouble with GROUP_CONCAT and Longtext in MySQL

If you have a large amount of data for the GROUP_CONCAT example above, you may need to change your group_concat_max_len to avoid a syntax error due to truncation.

SET SESSION group_concat_max_len=4096;

See: Trouble with GROUP_CONCAT and Longtext in MySQL

answered Jan 2, 2020 at 14:29

1

If you have a large amount of data for the GROUP_CONCAT example above, you may need to change your group_concat_max_len to avoid a syntax error due to truncation. SET SESSION group_concat_max_len=4096; See: Trouble with GROUP_CONCAT and Longtext in MySQL