通过select结果进行update例子:
UPDATE quality_task c INNER JOIN
(SELECT a.id as id, a.status as status, if(b.id is null,0,1) result from quality_task a
left join quality_issue b
on a.id=b.quality_task_id
where a.project_id>=1612 and a.project_id<=1620 and a.status=1
) d
on c.id=d.id
set c.status=2, c.result=d.result;
mysql通过select结果进行update
最新推荐文章于 2024-03-27 02:04:03 发布