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;
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIn5GcuIWMxgjZ0kTN2gzMjlTNwYTYhV2NkJGMiRmYwAjZ0EGOfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.png)
SELECT name ,GROUP_CONCAT(address order by address desc separator "#") address FROM t_aa GROUP BY name;