开发者

mysql & group_concat_length

Let say I have a table with million of rows.

Does this sql query stop as soon as "group_concat_length" limit value is reached for all "id_list" or does it test all rows in the table?

SELECT GROUP_CO开发者_JS百科NCAT(id) AS id_list, type FROM table WHERE 1 GROUP BY type


All rows and groups are processed

Only an individual aggregation is truncated

http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜