title: Alternative to MySQL's GROUP_CONCAT function
body: <p>I'm retrieving the data with MySQL function called "GROUP_CONCAT()".</p>
  
  <p>But when I checked the result of "GROUP_CONCAT()" function related column, it was missing some data. </p>
  
  <p>When I google the record missing issue with "GROUP_CONCAT()" function, in the official MySQL site they have mentioned as,</p>
  
  <p>There is a global variable called <a href="http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_group_concat_max_len" rel="nofollow noreferrer">group_concat_max_len</a> and it will permit the maximum result length in bytes for the GROUP_CONCAT() function, the default value of it as 1024. </p>
  
  <p>Therefore it seems I have to increase that value with following MySQL command, </p>
  
  <p><code>SET GLOBAL group_concat_max_len = 1000000</code>;</p>
  
  <p>Therefore set this value permanently, I have to edit the MySQL server related configuration file  (my.cnf or my.ini) and have to restart the server. </p>
  
  <p>But unfortunately I haven't any permission to do so. </p>
  
  <p>Therefore can you please help me to find out some alternative solution to fix this issue.</p>
  
  <p>Thanks a lot.</p>