MySQL and GROUP_CONCAT() maximum length

by 
SET SESSION group_concat_max_len = 1000000;

is a temporary, session-scope, setting. It only applies to the current session You should use it like this. 

SET SESSION group_concat_max_len = 1000000;
select group_concat(column) from table group by column

You can do this even in sharing hosting, but when you use an other session, you need to repeat the SET SESSION command.

More Related Contents:

  1. Can I concatenate multiple MySQL rows into one field?
  2. How to use GROUP_CONCAT in a CONCAT in MySQL
  3. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  4. What is the opposite of GROUP_CONCAT in MySQL?
  5. MySQL DISTINCT on a GROUP_CONCAT()
  6. GROUP_CONCAT ORDER BY
  7. GROUP_CONCAT with limit
  8. MySQL: Sort GROUP_CONCAT values
  9. How create json format with group-concat mysql?
  10. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  11. GROUP_CONCAT equivalent in Django
  12. is there a length limit to group_concat or another reason why it would not work on a text field
  13. Trouble with GROUP_CONCAT and Longtext in MySQL
  14. SQL Query needed for fetch value from Two identical table but not fully identical table
  15. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  16. MySQL: Insert record if not exists in table [duplicate]
  17. MySQL Query GROUP BY day / month / year
  18. How do I change the data type for a column in MySQL?
  19. mysql fulltext search failure
  20. Adding a leading zero to some values in column in MySQL
  21. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  22. Export a MySQL Database to SQLite Database
  23. SQL search multiple values in same field
  24. Removing duplicates with unique index
  25. MySQL – Select the last inserted row easiest way
  26. Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?
  27. ALTER table – adding AUTOINCREMENT in MySQL
  28. How to kill MySQL connections
  29. `MODIFY COLUMN` vs `CHANGE COLUMN`
  30. How to solve MySQL max_user_connections error

Leave a Comment