这段SQL语句用于将cm_serviceattr_instance表中的attrcode字段设置为pub_serviceattr_def表中对应的attrcode值，通过serviceattrid进行匹配。更新操作仅针对serviceattrid存在于pub_serviceattr_def表中的记录。
UPDATE cm_serviceattr_instance a
SET a.attrcode = (SELECT b.attrcode
FROM pub_serviceattr_def b
where a.serviceattrid = b.serviceattrid)
where a.serviceattrid in(select b.serviceattrid from pub_serviceattr_def b);
SET a.attrcode = (SELECT b.attrcode
FROM pub_serviceattr_def b
where a.serviceattrid = b.serviceattrid)
where a.serviceattrid in(select b.serviceattrid from pub_serviceattr_def b);
扫一扫
1812
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
