开发者

mysql & group_concat_length

开发者 https://www.devze.com 2023-04-08 16:39 出处:网络
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?

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

精彩评论

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