版权声明:本文为博主原创文章,无需授权即可转载,甚至无需保留以上版权声明,转载时请务必注明作者。
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;
2)设置 GROUP_CONCAT
SET GLOBAL group_concat_max_len=102400;
SET SESSION group_concat_max_len = 102400;