mysql按天汇总数据

# 按天统计数据
select
    DATE_FORMAT(f_create_time,'%Y-%m-%d') as dt,
    count(*) as cnt
from t_trans_07_0
where f_create_time>='2020-03-01'
group by dt;