SELECT DATE_FORMAT(c.`consumeCjTime`,"%Y-%m-%d") AS `day`, SUM(c.`consumeTotalPrice`) AS `totalPrice` FROM `consume` AS c
SELECT DATE_FORMAT(c.`consumeCjTime`,"%Y-%m-%d"
阅读背景：
MySQL 按天分组统计
来源：互联网
分享到：
