Sql Stored Procedure - Variable Too Short

I have a mySQL stored procedure that work with few data in a table : SQL Fiddle Demo -> thanks to Mahmoud Gamal for this. The problem is that this precedure doesn't work with ma

Solution 1:

Yes, this can be a problem of GROUP_CONCAT function, it has a limitation.

Run this query - SELECT @@local.group_concat_max_len; It will return the maximum allowed result length for the GROUP_CONCAT() function.

You need to increase this value, for example -

SET @@local.group_concat_max_len=10000;