欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

Mysql update关联其他表,子查询,对应多条数据取最新一条

程序员文章站 2022-06-01 17:23:38
...
	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