mysql统计最近12月数据–查询倒推12月份
select date_format(curdate(),'%Y-%m') AS `mon` union
select date_format((curdate() - interval 1 month),'%Y-%m') AS `mon` union
select date_format((curdate() - interval 2 month),'%Y-%m') AS `mon` union
select date_format((curdate() - interval 3 month),'%Y-%m') AS `mon` union
select date_format((curdate() - interval 4 month),'%Y-%m') AS `mon` union
select date_format((curdate() - interval 5 month),'%Y-%m') AS `mon` union
select date_format((curdate() - interval 6 month),'%Y-%m') AS `mon` union
select date_format((curdate() - interval 7 month),'%Y-%m') AS `mon` union
select date_format((curdate() - interval 8 month),'%Y-%m') AS `mon` union
select date_format((curdate() - interval 9 month),'%Y-%m') AS `mon` union
select date_format((curdate() - interval 10 month),'%Y-%m') AS `mon` union
select date_format((curdate() - interval 11 month),'%Y-%m') AS `mon`
该语句可以用于条形图统计,横坐标最近12个月份节点展示;
可用于连接查询数据集合。