MySQL Forums
Forum List  »  Performance

Re: Setting group_concat_max_len
Posted by: Rick James
Date: May 30, 2010 06:43PM

Well, you could calculate the exact size needed:

SELECT @gcml :=
     SUM(LENGTH( XML ))  -- The main part
   + COUNT(*)-1   -- the commas
FROM ...
SET @group_concat_max_len = @gcml;
SELECT GROUP_CONCAT(XML) ...

Options: ReplyQuote


Subject
Views
Written By
Posted
18769
May 25, 2010 04:00PM
3511
May 28, 2010 07:18PM
2991
May 29, 2010 10:33PM
3959
May 30, 2010 04:48PM
Re: Setting group_concat_max_len
2352
May 30, 2010 06:43PM
2231
June 04, 2010 06:27AM
2023
June 04, 2010 07:10AM
3852
June 04, 2010 10:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.