SET SESSION for SQL query
I am running query which contains a group concat. The max length for group concat is 1024 characters, but the result i am looking for is longer in some cases.
This can be circumvented by running "SET SESSION group_concat_max_len = 1000000;" before the SELECT query. I have tried this in MySQL workbench and it works, but unfortunately it doesnt in SuperMetrics.
It seems someone else has run into t his problem before and it was fixed, but it doesnt work for me. Do you have any idea what im doing wrong?