(time,’%Y%m%d’) as dt,count(*) as count from ty.count where time>date_sub(curdate(),interval 1 day) group...其他的时间单位也是合法的如:QUARTER, WEEK, YEAR_MONTH,DAY_HOUR,DAY_MINUTE,DAY_SECOND,HOUR_MINUTE,HOUR_SECOND, MINUTE_SECOND,不建议使用这些不标准的时间单位...(DATE_ADD(DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())-1 DAY), INTERVAL 1 MONTH),INTERVAL 1 HOUR)
ON COMPLETION...(DATE_ADD(DATE( CONCAT(YEAR(CURDATE()),’-‘,ELT(QUARTER(CURDATE()),1,4,7,10),’-‘,1)),INTERVAL 1 QUARTER...(DATE(CONCAT(YEAR(CURDATE()) + 1,’-‘,1,’-‘,1)),INTERVAL 4 HOUR)
ON COMPLETION PRESERVE ENABLE
DO
BEGIN