mysql通过select结果进行update
通过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 aleft join quality_issue bon a.id=b.quality_task_idwhere a.project_id>=1612 and a.project_id<=1620 and a.
原创
2021-06-25 17:03:17 ·
3310 阅读 ·
0 评论