SQL的GROUP_CONCAT（）函数使用

SQL的GROUP_CONCAT（）函数使用

思路:按照相同记录字段的分组，然后将不同记录字段，进行连接。

SELECT
	self_num,
	license_num,
	binging_name,
	binding_phone 
FROM
	car_driver_relation

SELECT
	car_driver_relation.self_num as '自编号',
	car_driver_relation.license_num as '车牌号',
	GROUP_CONCAT( car_driver_relation.binding_phone ) as '司机手机号',
	GROUP_CONCAT( car_driver_relation.binging_name ) as '司机'
FROM
	car_driver_relation
GROUP BY
	car_driver_relation.self_num,car_driver_relation.license_num