--1
update o2o_shop_info_app a set citycode=(select id from shop_area b
where a.city1=b.areaname
)
where pt_name='饿了么h5' and province1='河北省'
--2
update o2o_shop_info_app a set adcode=(select id from shop_area b
where b.areaname=a.district and
a.citycode =b.parentid
)
where pt_name='饿了么h5' and province1='河北省'
update o2o_shop_info_app a set citycode=(select id from shop_area b
where a.city1=b.areaname
)
where pt_name='饿了么h5' and province1='河北省'
--2
update o2o_shop_info_app a set adcode=(select id from shop_area b
where b.areaname=a.district and
a.citycode =b.parentid
)
where pt_name='饿了么h5' and province1='河北省'
1018
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
