SELECT userid,username, concat('【',group_concat(cardid_all ORDER BY cardid_all separator '】【'),'】') AS cardid_all FROM reports.upper_report_detail WHERE reports.upper_report_detail.rep_id ='10762' GROUP BY userid
|
||||||||||
棚号 | 姓名 | 环号 | ||||||||
001374 | 长胜旺旺 | 【6661443,6661445,6661448,6661449,6661454,6661458,6661478,6662691,6662700,6662708,6662714,6662717,6662729】 |