CODEWITHSUNDEEP
mysqlgroup-concat
Darm
Darm

Reputation: 5659

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_CONCAT(id) AS id_list, type FROM table WHERE 1 GROUP BY type

Upvotes: 3

Views: 169

Answers (1)

gbn
gbn

Reputation: 432271

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

Upvotes: 1

Related Questions