Multiple rows of query results in MySQL are merged into a single

Use the function: Group_concat (), to implement an ID corresponding to multiple names, originally multiple rows of data, the name is merged into a row, such as | 10,20,20|

Group_concat function in MySQL
The complete syntax is as follows:
Group_concat ([DISTINCT] field to connect [order by Asc/desc sort field] [Separator ' delimiter '])

Basic Query

Select  as  as  from GROUP  by yiyuan_id

Results:

Time: 0.805s
Thief is convenient, super easy to use, faster than writing programs

Multiple rows of query results in MySQL are merged into a single