mysql如何提取两个日期之间的所有数据

select create_date,count(*) as regeister from tablename where create_date between 'startdate' and 'enddate' group by create_date

mysql 怎么获取前一个月的日期和前一年的日期

set @dt = now()

select extract(year_month from date_add(@dt, interval -1 month))

select extract(year_month from date_add(@dt, interval -1 year))

这样就可以了

---