GROUP_CONCAT() in a MySQL query to convert multiple rows into a single string. However, the maximum length of the result of this function is 1024 characters.
SET SESSION group_concat_max_len = 1000000;Above is set for SESSION
SET GLOBAL group_concat_max_len = 1000000;
above is set for GLOBAL
0 comments:
Post a Comment