编辑 | blame | 历史 | 原始文档

分公司要配置出发地址
更新表数据
select ServiceBranch,ServiceAddress,ServiceAddress_lat,ServiceAddress_lng,UnitName,UnitShort,ServiceMinPrice,ServiceUnitPrice,ServiceLong from IntroducerUnitData where UnitState>0 and ServiceAddress_lat is not null and ServiceAddress_lng is not null and ServiceBranch='SZ'

update IntroducerUnitData set ServiceAddress='深圳市龙岗区平湖大街159号和风居', ServiceAddress_lat=22.684596,ServiceAddress_lng=114.155988 where UnitID=80