DATE_FORMAT( datetime列, ‘%Y-%m-%d’ ) AS 日期,
SUM( … ) AS 合计,
COUNT( … ) AS 行数
FROM
表
GROUP BY
DATE_FORMAT( datetime列, ‘%Y-%m-%d’ )
时间:2018-09-15 23:30:04
DATE_FORMAT( datetime列, ‘%Y-%m-%d’ ) AS 日期,
SUM( … ) AS 合计,
COUNT( … ) AS 行数
FROM
表
GROUP BY
DATE_FORMAT( datetime列, ‘%Y-%m-%d’ )
mysql 查询锁 mysql – 数据库 – 前端 将sql文件导入mysql
2024-08-14