https://blog.csdn.net/qq_35393693/article/details/81224774
update edu_user_copy du,(select stuNum from edu_user_copy
where company like '小盒子学院%' group by stuNum having count(stuNum)>1) b
set du.stuNum=concat('hr',b.stuNum)
where du.stuNum=b.stuNum;
https://blog.csdn.net/qq_35393693/article/details/81224774
update edu_user_copy du,(select stuNum from edu_user_copy
where company like '小盒子学院%' group by stuNum having count(stuNum)>1) b
set du.stuNum=concat('hr',b.stuNum)
where du.stuNum=b.stuNum;
本文标题:update 子查询
本文链接:https://www.haomeiwen.com/subject/rdfghktx.html
网友评论