mybatis比较日期大小 mysql_MySQL与mabits大小比较、日期比较示例

首先，使用mysql查询从今往后的60天数据

SELECT

count(*),

b1.record_date

FROM

nk_house_use_record AS b1,

(

SELECT

a.theme_id,

a.theme_name,

b.house_id,

b.house_name

FROM

nk_house_theme AS a,

nk_house AS b

WHERE

a.theme_id = '08a649fd-b83e-41b5-b88b-99598d4c93fe'

AND a.theme_id = b.theme_id

AND a.state = '1'

AND b.state = '1'

) AS a1

WHERE

a1.house_id = b1.house_id

AND time1 = '0'

AND record_date >= CURDATE() #'2016-06-05'

AND record_date < DATE_SUB(CURDATE(), INTERVAL - 60 DAY)

GROUP BY

b1.record_date

其次，移植到mabits中

SELECT

count(*) AS num,

b1.record_date

FROM

nk_house_use_record AS b1,