小组联合会议结果截止 [英] Group Concat Results Cut Off

问题描述

我正在使用以下查询，它返回的是预期结果..除了连接的结果似乎被切断之外.

I'm using the following query and it's returning the expected results.. except for the fact that the concatenated results appear to be cut off.

示例:

"1965 Chevrolet Suburban, 
1958 Chevrolet Bel Air, 
1969 Chevrolet K20 Suburban, 
1967 Chevrolet Bel Air, 
1964 Chevrolet C10 Pickup, 
1970 Chevrolet G10 Van, 
1969 Chevrolet K20 Pickup, 
1965 Chevrolet Biscayne, 
1970 Chevrolet Brookwood, 
1964 Chevrolet P30 Series, 
1966 Chevrolet Bel Air, 
1967 Chevrolet C20 Pickup, 
1972 Chevrolet Blazer, 
1961 Chevrolet Biscayne, 
1962 Chevrolet Corvair, 
1968 Chevrolet Impala, 
1970 Chevrolet K30 Pickup, 
1967 Chevrolet C10 Pickup, 
1966 Chevrolet G10 Van, 
1968 Chevrolet K20 Pickup, 
1963 Chevrolet P30 Series, 
1966 Chevrolet C30 Pickup, 
1963 Chevrolet Corvair, 
1970 Chevrolet P20 Van, 
1960 Chevrolet Bel Air, 
1959 Chevrolet Biscayne, 
1963 Chevrolet Chevy II, 
1964 Chevrolet P20 Series, 
1962 Chevrolet C30 Pickup, 
1972 Chevrolet Biscayne, 
1962 Chevrolet C10 Pickup, 
1965 Chevrolet C30 Pickup, 
1967 Chevrolet G10 Van, 
1970 Chevrolet Bel Air, 
1969 Chevrolet Corvair, 
1971 Chevrolet C10 Suburban, 
1959 Chevrolet Impala, 
1971 Chevrolet Camaro, 
1967 Chevrolet Impala, 
1962 Chevrolet Impala, 
1964 Chevrole"

如您所见，它正在被截断-我希望所有结果都被填充而不会被截断.

As you can see, it's being cut off -- I'd like for all of the results to be populated without being cut off.

谢谢！

推荐答案

GROUP_CONCAT()函数的默认限制为1024个字符.

The GROUP_CONCAT() function has a default limit of 1024 characters.

SET SESSION group_concat_max_len = 1000000;

如果需要，此命令将提高组连接限制.

This command will raise the group concat limit if needed.

这篇关于小组联合会议结果截止的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！