mysql查询表内某字段每日更新的分布量

使用Date()

select date(createDate),statusCode,count(statusCode) From table_name group by ate(createDate),statusCode