1SET @@SESSION.sql_buffer_result= 1;
2CREATE TABLE t1(grp INT, a INT UNSIGNED, c CHAR, d CHAR);
3SELECT grp, GROUP_CONCAT(c ORDER BY 2) FROM t1 GROUP BY grp;
4grp	GROUP_CONCAT(c ORDER BY 2)
5DROP TABLE t1;
6