update table1 as t1
LEFT JOIN table2 as t2 ON t1.tasksub_id = t2.id
set receive_state = 1
where t1.id = 1
update left join 多表关联更新
最新推荐文章于 2022-12-20 14:56:02 发布
update table1 as t1
LEFT JOIN table2 as t2 ON t1.tasksub_id = t2.id
set receive_state = 1
where t1.id = 1