Mysql临时表创建查询修改

 
create temporary table tmp_mouth2 (
`mouth` VARCHAR(10) NOT NULL,
`count` INTEGER NOT NULL);
 
INSERT INTO tmp_mouth2 VALUES(2,0),(3,0),(4,0),(5,0),(6,0),(7,0),(8,0),(9,0),(10,0),(11,0),(12,0);
 
SELECT
	t.mouth,
	s.c as count
FROM
	tmp_mouth2 AS t
	LEFT JOIN (
	SELECT MONTH
		( createdTime ) AS m,
		COUNT( id ) AS c 
	FROM
		questionnaire_record 
	GROUP BY
	MONTH ( createdTime )) AS s ON s.m = t.mouth;
 
 
 
drop temporary table `tmp_mouth2`;

实现查询每个月份多少条数据