使用left join,或join等进行关联,条件相等的进行修改
update took_activity_order o left join took_activity_user u on o.activity_user_id= u.id
set o.recommend_id = u.recommend_id, o.recommend_ids= u.recommend_ids
where o.activity_user_id= u.id;
使用left join,或join等进行关联,条件相等的进行修改
update took_activity_order o left join took_activity_user u on o.activity_user_id= u.id
set o.recommend_id = u.recommend_id, o.recommend_ids= u.recommend_ids
where o.activity_user_id= u.id;