DATE_FORMAT( datetime列, ‘%Y-%m-%d’ ) AS 日期,
SUM( … ) AS 合计,
COUNT( … ) AS 行数
FROM
表
GROUP BY
DATE_FORMAT( datetime列, ‘%Y-%m-%d’ )
时间:2018-08-11 05:00:10
DATE_FORMAT( datetime列, ‘%Y-%m-%d’ ) AS 日期,
SUM( … ) AS 合计,
COUNT( … ) AS 行数
FROM
表
GROUP BY
DATE_FORMAT( datetime列, ‘%Y-%m-%d’ )