在表上运行查询时,group_concat被剪切 [英] group_concat was cut when running a query on table
本文介绍了在表上运行查询时,group_concat被剪切的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个看起来像这样的表:
I have a table that looks likes this:
此表包含343行.
我正在尝试对其执行以下查询:
I'm trying to run this query on it:
create table newTest2
select function_name, service_name, min(concurrency), substring_index(group_concat(date order by concurrency ), ',',1) as minDate,
max(concurrency), substring_index(group_concat(date order by concurrency desc), ',',1) as maxDate , avg(concurrency)
from conc_intermidate
group by function_name,service_name;
,当我运行查询时,它给我:第203行被GROUP_CONCAT()割掉了",我不知道为什么它给了我这个错误.请帮忙!谢谢...
and when I run the query it gives me the : "row 203 was cut by GROUP_CONCAT()", I don't know why it's giving me this error. Please HELP! thanks...
推荐答案
感谢RobertRozas为我提供了类似的帖子
我运行了SET group_concat_max_len=15000;
,查询运行得很好.
Thanks to RobertRozas for providing me with similar post MySQL "Row 30153 was cut by GROUP_CONCAT()" error
I ran SET group_concat_max_len=15000;
and the query ran perfectly.
这篇关于在表上运行查询时,group_concat被剪切的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文