Trouble with GROUP_CONCAT and Longtext in MySQL

by

According to the MySQL manual, the maximum length of GROUP_CONCAT is defined by the group_concat_max_len system variable, which defaults to 1024.

This value can be increased, by using the following command:

SET group_concat_max_len = <int>

It should be noted, however, that the value of group_concat_max_len is itself limited by the value of another system variable, max_allowed_packet, which defaults to 1,048,576.

This value can be increased to a maximum of 1,073,741,824, using the same syntax:

SET max_allowed_packet = <int>

More Related Contents:

  1. Can I concatenate multiple MySQL rows into one field?
  2. MySQL and GROUP_CONCAT() maximum length
  3. How to use GROUP_CONCAT in a CONCAT in MySQL
  4. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  5. What is the opposite of GROUP_CONCAT in MySQL?
  6. MySQL DISTINCT on a GROUP_CONCAT()
  7. GROUP_CONCAT ORDER BY
  8. GROUP_CONCAT with limit
  9. MySQL: Sort GROUP_CONCAT values
  10. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  11. How create json format with group-concat mysql?
  12. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  13. GROUP_CONCAT equivalent in Django
  14. is there a length limit to group_concat or another reason why it would not work on a text field
  15. Recreating a query using INNER JOIN? [duplicate]
  16. Create a Cumulative Sum Column in MySQL
  17. mysql select dynamic row values as column names, another column as value
  18. Setting up MySQL and importing dump within Dockerfile
  19. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  20. Simple Random Samples from a Sql database
  21. node.js mysql error: ECONNREFUSED
  22. MySQL foreign key to allow NULL?
  23. MySQL : When stored procedure parameter name is the same as table column name
  24. Does a UNIQUE constraint automatically create an INDEX on the field(s)?
  25. MySQL 5.0 indexes – Unique vs Non Unique
  26. MySQL – Select from a list of numbers those without a counterpart in the id field of a table
  27. MySql – How get value in previous row and value in next row? [duplicate]
  28. Updating table in trigger after update on the same table
  29. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment