mysql分组后取第一条数据:结合function完成
UPDATE
(SELECT
(
SELECT
vrid
FROM
visit_record
WHERE
cid = ic.cid
ORDER BY
visit_time DESC
LIMIT 0,
1
) vrid,
ic.*
FROM
intention_customer ic
WHERE
1 = 1
AND ic.visit_time IS NULL
) iic
LEFT JOIN visit_record vr ON vr.vrid = iic.vrid
LEFT JOIN intention_customer ic ON ic.cid=iic.cid
SET ic.visit_time=vr.visit_time , ic.visit_content=vr.content
WHERE vr.vrid is NOT NULL