update tb_order_details a , ( select ot.order_details_id, max(ot.timeline_date) as timeline_date from tb_order_timeline ot where ot.deleted = false and ot.type = 43 group by ot.order_details_id ) b
set a.attributes = JSON_SET(a.attributes, '$.applyForClaimsDate', DATE_FORMAT( b.timeline_date ,'%Y-%m-%d %H:%i:%s'))
where a.id = b.order_details_id
AND a.id = 1082471611651268608
Mysql update关联其他表,子查询,对应多条数据取最新一条
最新推荐文章于 2022-05-11 11:22:30 发布