SELECT DATE_FORMAT(DATE_ADD(
CONCAT(YEAR(DATE(NOW())),’-01-01′),
INTERVAL (CAST( help_topic_id AS SIGNED )) MONTH ),’%m’) months
FROM mysql.help_topic
WHERE help_topic_id < 12 ORDER BY months ASC
从另一张表查询本年度各月份数据
SELECT z.months as timer,COUNT(s.create_time) as ct
from (SELECT DATE_FORMAT(DATE_ADD(
CONCAT(YEAR(DATE(NOW())),’-01-01′),
INTERVAL (CAST( help_topic_id AS SIGNED )) MONTH ),’%m’) months
FROM mysql.help_topic
WHERE help_topic_id < 12 ORDER BY months ASC) z
LEFT JOIN (SELECT * from com_wrfz_sb
where DATE_FORMAT(create_time,’%y’) = DATE_FORMAT(NOW(),’%y’)) s
on DATE_FORMAT(s.create_time,’%m’) = z.months
GROUP BY z.months ORDER BY z.months asc