MySQL查询今日、昨日、近7天、近30天、近一年的数据

select count(*) from access_log where DATEDIFF(create_time, NOW()) = -1;

select count(*) from access_log where to_days(create_time) = to_days(now());

select count(*) from access_log where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(create_time);

select count(*) from access_log where create_time >= DATE_SUB(NOW(), INTERVAL 30 DAY);

select count(*) from access_log where YEAR(create_time)=YEAR(NOW());