sql语句,数据中存的时间戳,如何查询一段时间每天的统计
SELECT
count(*) AS counter,timedate
FROM
(
SELECT
*, date_format(
from_unixtime(c.时间戳名),
'%Y-%m-%d'
) AS timedate
FROM
表名 AS c
) temp
WHERE
timedate >= '2015-01-06'
AND timedate <= '2015-11-08'
GROUP BY
timedate