cain's recent timeline updates cain's recent timeline updates | cainV2EX member #347, joined on 2010-05-03 11:14:23 +08:00Today's activity rank 13004 |
| 电商系统部分模块外包 外包 cain Oct 29, 2017 Lastly replied by cain | 5 |
| 仿一个 http://airware.com/ 问与答 cain Sep 12, 2014 Lastly replied by vibbow | 3 |
| iPhone 与未连接无线路由器的设备交互 问与答 cain Jul 17, 2014 Lastly replied by ipconfiger | 2 |
| MBA 为啥关机还会消耗电池 1 问与答 cain Apr 30, 2014 Lastly replied by Coda | 6 |
| 我对 npm 完全无语了 问与答 cain Apr 3, 2014 Lastly replied by zhangdawei | 15 |
| 大家可否推荐上海靠谱MBP非官方修理点 MacBook Pro cain Apr 29, 2013 |
| 有谁有闲置的60W magsafe么 二手交易 cain Jan 30, 2013 |
cain's recent replies
Mar 13, 2023 Replied to a topic by Mason2021 程序员 分享： Zed 编辑器邀请链接 |
Jul 1, 2020 Replied to a topic by HanHanNetizen 职场话题 是否有必要去坡县 |
Apr 21, 2018 Replied to a topic by yamyamyuo 求职 想找 Python 的兼职讲师职位 |
联系方式？
Aug 28, 2017 Replied to a topic by xiaozy 问与答 PHP 按距离分页排序问题 |
SELECT
id, lng, lat,
(st_distance (point (lng, lat), point({dest_lng}, {dest_lat}) ) / 0.0111) AS distance
FROM
locations
HAVING distance < 50
ORDER BY distance
类似这样，使用 mysql 内置 geo spatial functions
Ref: https://dev.mysql.com/doc/refman/5.6/en/spatial-function-reference.html
id, lng, lat,
(st_distance (point (lng, lat), point({dest_lng}, {dest_lat}) ) / 0.0111) AS distance
FROM
locations
HAVING distance < 50
ORDER BY distance
类似这样，使用 mysql 内置 geo spatial functions
Ref: https://dev.mysql.com/doc/refman/5.6/en/spatial-function-reference.html
Jul 11, 2017 Replied to a topic by bw2 程序员 我们一起来做一道 JS 题目：在控制台打印 React 仓库的 Fork 列表 |
时间统计可以用 window.performance.now() 代替获取时间的方法
Sep 26, 2014 Replied to a topic by yeshiwei macOS 用了 mac os x 之后才知道，ubuntu 是 mac 的蹩脚的模仿者。之前在 ubuntu 里面看到设计优秀，体验糟糕的功能，原来在 mac 里面是如此的天人合一。 |
另外说linux丑的都是不懂调教的。。。另外xfce自带的tile window的功能在mac上还要装一个shiftit。
Select Language