update jigou_temp t set t.area=
(select z.code from zipcode z
where substr(t.shi,0,2) = substr(z.city,0,2) and substr(t.quxian,0,2) = substr(z.county,0,2) and t.area='999999' and z.type='county'
)
where exists
(select z.code from zipcode z
where substr(t.shi,0,2) = substr(z.city,0,2) and substr(t.quxian,0,2) = substr(z.county,0,2) and t.area='999999' and z.type='county'
)
语句
最新推荐文章于 2022-11-01 13:19:48 发布
扫一扫
4122
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
