mysql多条记录拼接方法

select group_concat(`title`) from test

select group_concat(`title`,`id`) from test

group_concat

查询拼接表字段名：

SELECT GROUP_CONCAT(COLUMN_NAME) FROM information_schema.COLUMNS WHERE table_name = '表名' and table_schema = '库名';

指定分隔符号：

GROUP_CONCAT(OD.product_name SEPARATOR "，")

SELECT

O.order_number AS orderNumber,

GROUP_CONCAT(OD.product_name SEPARATOR "，") AS productName

FROM order O

LEFT JOIN order_detail OD ON O.id = OD.order_id 

GROUP BY O.id