解決 sql_mode=only_full_group_by
企業(yè)微信截圖_1598344385325.png
用mysql 的any_value函數(shù)包起來(lái)
示例（報(bào)錯(cuò)寫(xiě)法）
SELECT
DISTINCT a.id,a.answer_user_id as user_id,u.user_name,u.dep_id,au.nickname,a.choose_content,a.sign_image,a.subject_id,a.type,a.create_time,FROM_UNIXTIME(a.create_time,"%Y-%m-%d %H:%i:%s") as create_time_date,CONCAT(a.answer_user_id,a.create_time) AS hebing
,CONCAT('[',GROUP_CONCAT(CONCAT('{"subject_id":"',a.subject_id,'","subject_type":"',a.`type`,'","choose_content":',a.choose_content,'}'),','),']') AS ivi
FROM `mgtx_a_answer` `a`
LEFT JOIN `mgtx_user` `u` ON `a`.`answer_user_id`=`u`.`user_id`
LEFT JOIN `mgtx_a_wx_user` `au` ON `a`.`answer_user_id`=`au`.`openid`
WHERE `a`.`questionnaire_id` = 8593 AND `a`.`answer_user_id` IS NOT NULL GROUP BY a.answer_user_id -- ORDER BY `a`.`subject_id` ASC
示例 （解決寫(xiě)法）
SELECT
DISTINCT ANY_VALUE(a.id),a.answer_user_id as user_id,ANY_VALUE(a.sign_image),ANY_VALUE(a.subject_id),ANY_VALUE(a.type)
,ANY_VALUE(a.create_time),FROM_UNIXTIME(ANY_VALUE(a.create_time),"%Y-%m-%d %H:%i:%s") as create_time_date,CONCAT(a.answer_user_id,ANY_VALUE(a.create_time)) AS hebing
,CONCAT('[',GROUP_CONCAT(CONCAT('{"subject_id":"',a.subject_id,'","subject_type":"',a.`type`,'","choose_content":',a.choose_content,'}'),','),']') AS ivi
FROM `mgtx_a_answer` `a`
WHERE `a`.`questionnaire_id` = 8593 AND `a`.`answer_user_id` IS NOT NULL GROUP BY a.answer_user_id
企業(yè)微信截圖_1598344385325.png
