解决——》[Err] 1260 - Row 340 was cut by GROUP_CONCAT()

墨蓝 2024-02-19 19:50 55阅读 0赞

版权声明：本文为博主原创文章，无需授权即可转载，甚至无需保留以上版权声明，转载时请务必注明作者。  
[https://blog.csdn.net/weixin\_43453386/article/details/89190063][https_blog.csdn.net_weixin_43453386_article_details_89190063]  
@\[TOC\](解决——》\[Err\] 1260 - Row 340 was cut by GROUP\_CONCAT())

### 1、操作 ###

数据库更新

### 2、现象（错误信息） ###

UPDATE house_hub_fence.tb_fence_community fc,
     house_asset.community c
    SET fc.community_addr = (
    	SELECT
    		GROUP_CONCAT(DISTINCT cad.address)
    	FROM
    		house_asset.community_addr cad
    	WHERE
    		cad.community_id = fc.community_id
    )
    WHERE
    	fc.community_id = c.community_id

`[Err] 1260 - Row 340 was cut by GROUP_CONCAT()`

### 3、原因 ###

GROUP\_CONCAT有个最大长度的限制，超过最大长度就会被截断掉

### 4、解决：扩大GROUP\_CONCAT的长度限制 ###

#### 1）查看 GROUP\_CONCAT （`1024：MySQL系统默认的最大长度`） ####

SELECT @@session.group_concat_max_len,@@session.group_concat_max_len;

![在这里插入图片描述][20190411172955270.png]

#### 2）设置 GROUP\_CONCAT ####

SET GLOBAL group_concat_max_len=102400;
    SET SESSION group_concat_max_len = 102400;

[https_blog.csdn.net_weixin_43453386_article_details_89190063]: https://blog.csdn.net/weixin_43453386/article/details/89190063
[20190411172955270.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/e06538e017ea45528a418f09d86dd0ca.png