MYSQL中GROUP_CONCAT和CONCAT函数配合使用

SELECT r.*,m.anchor_name,o.full_name,GROUP_CONCAT(DISTINCT CONCAT(e.early_warning_target_name,':'),e.early_warning_value,e.early_warning_value_unit) info 
FROM `t_pm_early_warning_record` r
LEFT JOIN `t_pm_monitor_anchor` m ON m.anchor_id = r.anchor_id 
LEFT JOIN `t_pm_project_info` p ON p.project_id = m.project_id
LEFT JOIN `t_pm_monitor_object` o ON o.monitor_object_id = r.monitor_object_id
LEFT JOIN `t_pm_early_warning_record_detail` e ON e.early_warning_record_id = r.early_warning_record_id
WHERE p.project_id IN ('40946A45B3B84D76B2F06DDB0D6B85E5') 
AND r.monitor_object_id IN ('B654B23C797246BAB77BE4C130892059')
GROUP BY r.early_warning_record_id 



注意看info这一列，先根据group_concat 多列合并为一列，默认以“,”分割；然后通过concat按自己的需求拼接字符串.(这里以：分割)