SELECT
`id`,
`admin_id`,
`city`,
`lat`,
`lng`,
`status`,
`del`,
`business_id`,
hkj_distance (
`lat`,
`lng`,
30.307862,
120.105328
) AS dt
FROM
`sys_shop`
mysql 5.7 距离函数 hkj_distance
最新推荐文章于 2024-08-23 10:27:05 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)