Thursday, January 3, 2013

How to increase GROUP_CONCAT function length in MySQL

http://forums.pentaho.com/showthread.php?135082-how-to-add-maximum-length-for-GROUP_CONCAT-in-pentaho-report-designer&p=330725#post330725

GROUP_CONCAT() in a MySQL query to convert multiple rows into a single string. However, the maximum length of the result of this function is 1024 characters.

 I'm very well aware that I can change the param group_concat_max_len to increase this limit:

SET SESSION group_concat_max_len = 1000000;

Above is set for SESSION

SET GLOBAL group_concat_max_len = 1000000;

above is set for GLOBAL

ref :- http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat

http://rpbouman.blogspot.in/2008/07/calculating-nth-percentile-in-mysql.html

http://rpbouman.blogspot.in/2009_03_01_archive.html

Create MongoDB service in Windows OS

1) Open Command Prompt 2) Create directory for Database and Logs                    mkdir c:\data\db                     mkdir c:\...