zihandan的博客

一、公式如下，单位米：第一点经纬度：lng1 lat1第二点经纬度：lng2 lat2round(6378.138*2*asin(sqrt(pow(sin( (lat1*pi()/180-lat2*pi()/180)/2),2)+cos(lat1*pi()/180)*cos(lat2*pi()/180)* pow(sin( (lng1*pi()/180-lng2*pi()/

一、在写sql语句时如果想要将两组差不读相同的数据同时返回就会用到union 、union all 1、首先它俩的区别：union 去重、排序、效率稍慢；union all 不去重、不排序、效率比union 快所以如果并的两组数据没有重复数据用 union all 效率快2、两组数据对应的字段必须名称相同，如果一个有、一个没有，可以用占位表示‘’但是如果外面要套select * f

SELECTCASE WHEN a.order_status =1 THEN (CASE WHEN TO_DAYS(NOW()) - TO_DAYS(a.create_date) = 0 THEN CONCAT('今天',' ',DATE_FORMAT(a.create_date,'%H:%i')) WHEN TO_DAYS(NOW()) - TO_DAYS(a.create_date) =

SELECT a.trip_id AS tatoel,(UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(a.create_date))/60 AS cc FROM user_trip a LEFT JOIN world_city b ON b.city_id=a.start_city_id LEFT JOIN world_city c ON c.city_id=a.re

方法一：SELECT * FROM users WHERE emails like "%b@email.com%";方法二：利用MySQL 字符串函数 find_in_set();SELECT * FROM users WHERE find_in_set('aa@email.com', emails);方法三：使用locate(substr,str)函数，如果包

修改订单状态，变成已撤销 -->UPDATE order_info a a.order_status = 11,  a.undo_date = NOW()order_status=1 ANDUNIX_TIMESTAMP(NOW())-(UNIX_TIMESTAMP(a.create_date)+  (SELECT b.expire_time FROM scene

一、取出前n条数据 然后分页SELECT * ,(SELECT a.value FROM blue_base_config a WHERE a.KEY ='sendOrders') AS moneyLevelFROM (SELECT id,orderNo,createDate,expectDate FROM blue_order WHERE getFlag = 3 AND MONTH

一、条件语句，两个时间相差多少天 CASE WHEN DATEDIFF(main.overdue_time,SYSDATE()) >0 AND main.order_status ='2' THEN CONCAT('剩余:',DATEDIFF(main.overdue_time,SYSDATE()),'天') ELSE '' END AS restDay二、时间格式化DA...