ymr1248的博客

select a.click_date,ifnull(b.count,0) as count from ( SELECT DATE_FORMAT(date_sub(curdate(), interval 0 MONTH ),'%Y-%m') as click_date union all SELECT DATE_FORMAT(date_sub(curdate(), interval 1 MONTH ),'%Y-%m') as click_date union a.