http://guoliangqi.iteye.com/blog/628063
http://guoliangqi.iteye.com/blog/628063
select COUNT(1) as sum
from jfc_xxljob.xxl_job_log g
where
TIMESTAMPDIFF(MINUTE,concat(trigger_time,' ','Time'),NOW()) < 15
and job_id=8
http://guoliangqi.iteye.com/blog/628063
http://guoliangqi.iteye.com/blog/628063
select COUNT(1) as sum
from jfc_xxljob.xxl_job_log g
where
TIMESTAMPDIFF(MINUTE,concat(trigger_time,' ','Time'),NOW()) < 15
and job_id=8