[thelist] New JS/HTML/CSS IDE

Max Schwanekamp lists at neptunewebworks.com
Thu Nov 9 15:11:32 CST 2006


> From: Randal Rust
> > Tom
> > 43 % Nerd, 60% Geek, 17% Dork
> 
> 100% helpful:)

Er, 110%...?

<tip type="Giving MySQL's GROUP_CONCAT enough room" author="Max
Schwanekamp">
MySQL's GROUP_CONCAT[0,1] function is very useful at times, but it has a
default max length of just 1k, so before you use it for anything
concatenating anything more than 1 byte values, you might want to increase
its value to something a little more useful, e.g.:
SET SESSION group_concat_max_len = 8192;
[0] http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
[1] http://db4free.blogspot.com/2006/01/hail-to-groupconcat.html
</tip>

-- 
Max Schwanekamp
90% Nerd
 7% Geek
 3% Inert Ingredients
 






More information about the thelist mailing list