统计某年每个月的数据信息:
如何时间字段为int类型的秒数,mysql用
例如:SELECT HOUR(FROM_UNIXTIME(posttime_u)) AS hourtime,YEAR(FROM_UNIXTIME(posttime_u)) AS yeartime,COUNT(businessid) as count,businessid,posttime_u,FROM_UNIXTIME(posttime_u) from stats_hmp GROUP BY businessid,yeartime,hourtime