mysql函数

GROUP_CONCAT(exp) 需与group by语句在一起使用

 SELECT username,GROUP_CONCAT(address) FROM pinjie GROUP BY username;

SELECT username,GROUP_CONCAT(address separator  ",") FROM pinjie GROUP BY username;

SELECT name ,GROUP_CONCAT(address order by address desc separator "#") address FROM t_aa GROUP BY name;

mysql函数

标签：技术   esc   post   bsp   from   语句   order by   user   info