Mysql's Group_concat function uses the example _mysql

MySQL group_concat function, the complete syntax is as follows:

Copy Code code as follows:

Group_concat ([DISTINCT] The field to connect [order by Asc/desc sort field] [Separator ' delimiter]]

Basic Query

Copy Code code as follows:

select * from AA;

Copy Code code as follows:

+------+------+
| id| name |
+------+------+
|1 | 10|
|1 | 20|
|1 | 20|
| 20|
|3 | 200 |
|3 | 500 |
+------+------+
6 rows in Set (0.00 sec)

Grouped by ID, print the value of the Name field on one line, separated by commas (default)

Copy Code code as follows:

Select Id,group_concat (name) from AA Group by ID;