
update zycxCity zc
set provincecode = (select provincecode from zycxProvince zp WHERE zc.province = zp.provinceName)
where exists(select 1 from zycxProvince zcp where zc.province = zcp.provinceName)

update zycxCity zc
set provincecode = (select provincecode from zycxProvince zp WHERE zc.province = zp.provinceName)
where exists(select 1 from zycxProvince zcp where zc.province = zcp.provinceName)

被折叠的 条评论
为什么被折叠?