set @mycnt = 0;
select date_add("2008-07-31",interval @mycnt :=@mycnt + 1 day) as day from t_prehandle_qeesoo_04 limit 31
上面这个SQL就可以列出8月份所有日期。
上面SQL里的2008-07-31指的是起始日期,limit 31 是指加31天。
t_prehandle_qeesoo_04是随便一个表,只要这个表有31行以上数据就行。
结果:day2008-08-012008-08-022008-08-032008-08-042008-08-052008-08-062008-08-072008-08-082008-08-092008-08-102008-08-112008-08-122008-08-132008-08-142008-08-152008-08-162008-08-172008-08-182008-08-192008-08-202008-08-212008-08-222008-08-232008-08-242008-08-252008-08-262008-08-272008-08-282008-08-292008-08-302008-08-31