- 按起止时间查询
where 1=1
<if test="startTime!=null">
AND DATE_FORMAT(a.data_time, "%Y-%m-%d") >= DATE_FORMAT(#{startTime},"%Y-%m-%d")
</if>
<if test="endTime!=null">
AND DATE_FORMAT(a.data_time, "%Y-%m-%d") <= DATE_FORMAT(#{endTime},"%Y-%m-%d")
</if>
如果不先格式化,会漏调最后一天的数据,至统计了0点的
- 对数据库中数字为null 的进行加减会得null,使用IFNULL 判断
sum(IFNULL(a.vehicle_counts,0)) as vehicle_counts,
sum(IFNULL(a.uncompleted_counts,0)) as uncompleted_counts
mysql 整除:5 div 2 =2
mysql 取余 5 mod 2=1