摘要： -- 计算两个地点的球面距离，单位千米 select city_name, round(st_distance_sphere(point(118.35, 24.49),point(lng, lat))/1000,2), update_time as distance from tb_vip_geo 阅读全文