mysq计算两个gps坐标的距离

来源:互联网 发布:纳溪区网络问政平台 编辑:程序博客网 时间:2024/05/20 11:27
SELECTs.map_lat,s.map_lng, 2 * 6378.137 * ASIN(SQRT(POW(SIN(PI() * (22.549438 - s.map_lat) / 360),2) + COS(PI() * 113.95717 / 180) * COS(s.map_lat * PI() / 180) * POW(SIN(PI() * (113.95717 - s.map_lng) / 360   ),2))) AS distanceFROMpoobo_store swhere s.map_lat is NOT null and s.map_lng is NOT nullORDER BY  distance 

0 0