mysql的七日时间数据查询语句

溜溜仔仔

于 2021-09-27 14:53:30 发布

阅读量1.9k

点赞数

分类专栏： java问题解决文章标签： mysql 物联网数据库

本文链接：https://blog.csdn.net/weixin_40935738/article/details/120508621

版权

java问题解决专栏收录该内容

31 篇文章 1 订阅

订阅专栏

SELECT DATE_SUB( CURRENT_DATE, INTERVAL help_topic_id DAY ) dt
FROM mysql.help_topic
WHERE help_topic_id BETWEEN 0 AND 6

从一张表查找近七天是否有数据，count

SELECT DATE_FORMAT(z.dt,'%m-%d') as time,COUNT(c.create_time) as ct
       from (SELECT DATE_SUB( CURRENT_DATE, INTERVAL help_topic_id DAY ) dt
       FROM mysql.help_topic
       WHERE help_topic_id BETWEEN 0 AND 6) z
       LEFT JOIN com_wrfz_sb c on DATE_FORMAT(c.create_time,'%y-%m-%d') = z.dt
       GROUP BY z.dt ORDER BY z.dt asc