mysql查询每个月中的每天的数据记录

select DATE_FORMAT(FROM_UNIXTIME(time),'%Y-%m-%d') as time ,uid,sum(num) as num from datelog where uid=1 group by DATE_FORMAT(FROM_UNIXTIME(time),'%Y-%m-%d')

　　

下面是结果：