mysql多行多列合并為一行一列

標籤：

ref : http://blog.csdn.net/priestmoon/article/details/7677452

 

group_concat:

group_concat(distinct name)

group_concat(name separator ‘;‘)  // 預設是,


group_concat(name order by name desc)

 

SELECT * FROM shelvesopbusinessrel;

SELECT s0.id,s0.listNum,s0.warehouseId,s0.businessQuantity,s0.productQuantity,s0.printDate,group_concat(rel.businessNum)
FROM shelvesoplist s0
left join shelvesopbusinessrel rel
on s0.id = rel.shelvesOpListId
GROUP BY s0.listNum
ORDER BY s0.id DESC
;

mysql多行多列合并為一行一列