MySql update与select结合

 

 

  • 查询更新
UPDATE tab1 as  t1 INNER JOIN 
     tab2  as t2
ON t1.sampleId= t2.sampleId   
set t1.TaskCon='4' 
where t2.GroupCode='5814344' AND t1.taskCon = '6'

 

posted @ 2024-06-06 16:07  低调码农哥!  阅读(14)  评论(0)  编辑  收藏  举报