SQL 查询返回时间段

set @mycnt = 0;
select date_add("2015-07-01",interval @mycnt :=@mycnt + 1 day) as day from t_weixin limit 10


-- 定义自增变量
set @i = -1;
-- 创建指定日期间记录数天数需要 加 1
set @sql = repeat(" select 1 union all",-datediff('2012-09-01','2012-09-10')+1);
-- 将最后一个union all 去掉，这里前边加1个空格，就不用在减1了
set @sql = left(@sql,length(@sql)-length(" union all"));
-- 拼接sql
set @sql = concat("select date_add('2012-09-01',interval @i:=@i+1 day) as date from (",@sql,") as tmp");

prepare stmt from @sql;
execute stmt;