GION

select date_format(create_date,'%y/%m/') dates, count(*) id from access_log group by dates order by dates;

SELECT create_date FROM access_log WHERE TO_DAYS(NOW()) - TO_DAYS(create_date) <= 30 GROUP BY create_date;

SELECT COUNT(*) FROM access_log where create_date <= (select date_add(now(), interval -2 month));

• • • • • • • • • • • • • • • • • +

dates

id

• • • • • • • • • • • • • • • • • +

07/07/	7116
07/08/	34110
07/09/	40857
07/10/	39434
07/11/	36044
07/12/	34245
08/01/	33229
08/02/	7057

• • • • • • • • • • • • • • • • • +

ページを開くのにかかる時間42s

Total:232,091