一些mysql中的知识点

1.mysql中经度纬度存储问题

采取的是：java中使用Double类型，mysql中：

也是百度出来的，后来听别人说经纬度小数点不止6位数，具体没咋研究。。。（就简单记录一下吧）

2.统计周一到周日的次数 WEEkDAY的使用

"Mon","Tues","Wed","Thur","Fri","Sat","Sun" 从0开始

<select id="getCount" resultType="int">
 select count(1) from info 
 where delete_flag = 0 and WEEKDAY(time)=#{i} 
 and YEARWEEK(DATE_FORMAT(atime,'%Y-%m-%d'),1)=YEARWEEK(NOW(),7)
 <if test="status != null">and status = #{status}</if>
</select>