在表上运行查询时，group_concat被剪切 [英] group_concat was cut when running a query on table

问题描述

我有一个看起来像这样的表:

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屋！