Mysql 查询近半年的数据

#查询近半年的数据
select * 
from youTable
where time_colume>=curdate()- interval 6 month

#查询近3年的数据
select * 
from youTable
where time_colume>=curdate()- interval 3 year

2.按月份汇总数据

#查询近半年的数据,并且按照月份汇总

select concat(year(time_colume),month(time_colume)) as data, sum(amount) as total_amount

from youTable where time_colume>=curdate()- interval 6 month
group by month(time_column)

#查询近3年的数据，并且按照月份汇总

select concat(year(time_colume),month(time_colume))  as data, sum(amount) as total_amount

from youTable 
where time_colume>=curdate()- interval 3 year
group by month(time_column)