![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MYSQL
蒲公英bhf
这个作者很懒,什么都没留下…
展开
-
mysql聚合操作:查询每天的最后时间
SELECT DATE_FORMAT(b.`bill_CjTime`,'%Y-%m-%d') AS d,MAX(b.`bill_CjTime`) AS t FROM `bill` AS b GROUP BY d;原创 2021-04-08 10:57:24 · 299 阅读 · 0 评论 -
MySQL 按天分组统计
SELECT DATE_FORMAT(c.`consumeCjTime`,"%Y-%m-%d") AS `day`, SUM(c.`consumeTotalPrice`) AS `totalPrice` FROM `consume` AS c WHERE c.`consumeCjTime`>='2018-03-27' AND c.`consumeCjTime`< '2018-03-31...原创 2018-03-28 11:15:41 · 2248 阅读 · 0 评论 -
Mysql 设置ID从1开始自增
Mysql 设置ID从1开始自增 ALTER TABLE 表名AUTO_INCREMENT=1;原创 2019-06-03 15:12:09 · 12743 阅读 · 0 评论