SELECTdc._date AS date,IFNULL( ccd.newsCount, 0 ) AS newsCount FROM(SELECT@s := @s + 1 AS _index,DATE( DATE_SUB( CURRENT_DATE, INTERVAL @s DAY ) ) AS _date FROM# 关联任意一张系统表; 一定的是系统表;mysql.help_topic,( SELECT @s := - 1 ) temp WHERE@s < 6 ORDER BY_date ) AS dcLEFT JOIN (SELECTcount( 1 ) AS newsCount,DATE( c.create_time ) createdate FROM`content` c _id = '888888888' AND c.dept_id = '1' GROUP BYcreatedate ) AS ccd ON dc._date = ccd.createdate GROUP BYdc._date
月份
SELECT CONVERT( t2.year_month_str, CHAR ) `month`,IFNULL( ccd.newsCount, 0 ) AS newsCount FROM(SELECT@rownum := @rownum + 1 AS num,date_format( DATE_SUB( now(), INTERVAL @rownum MONTH ), '%Y-%m' ) AS year_month_str FROM( SELECT @rownum := - 1 ) AS r_init,( SELECT c.help_topic_id FROM mysql.help_topic c LIMIT 12 ) AS c_init ) t2LEFT JOIN (SELECTcount( 1 ) AS newsCount,CONCAT( DATE_FORMAT( c.create_time, '%Y' ), '-', DATE_FORMAT( c.create_time, '%m' ) ) createdate FROM`content` c _id = '88888' AND c.dept_id = '1' GROUP BYcreatedate ) ccd ON ccd.createdate = t2.year_month_str GROUP BYt2.year_month_str
SELECT@cdate := date_add( @cdate, INTERVAL - 1 DAY ) AS date FROM( SELECT @cdate := date_add( CURDATE(), INTERVAL + 1 DAY ) FROM l_login_log ) d1 WHEREYEAR ( @cdate )= YEAR (CURDATE()) AND MONTH ( @cdate )= MONTH (CURDATE()) AND DAY ( @cdate ) > 1 ORDER BYdate
如果觉得《Sql 查询近几天 近几个月数据没有补0 当月天数》对你有帮助，请点赞、收藏，并留下你的观点哦！
