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)
根据一张表的某个字段去更新另一张表
最新推荐文章于 2023-07-07 17:34:21 发布