Errorcode [1260]; % dline (s) werecutbyGROUP_CONCAT (); _ MySQL

Errorcode [1260]; % dline (s) werecutbyGROUP_CONCAT (); GROUP_CONCAT has a maximum length limit. if the maximum length is exceeded, it will be truncated. you can obtain it through the following statement:

Mysql> SELECT @ global. group_concat_max_len;
+ ------------------------------- +
| @ Global. group_concat_max_len |
+ ------------------------------- +
| 1, 1024 |
+ ------------------------------- +
1024 is the default maximum length of the MySQL system. If your bid string is larger than this, the problem may occur.
Solution

1. add the following in the MySQL configuration file:

Group_concat_max_len = 102400 # Maximum length you want

2. execute the statement:

Mysql> set global group_concat_max_len = 102400;

Then run the group_concat statement.