http://slava-technical.blogspo...eate-sequence-of-dates-in.html
Code:
select ADDDATE('2009-09-08', @c:=@c+1) as DAY
from (select @c:=-1) counter
inner join BIG_TABLE b on (1=1) limit 10;
select ADDDATE('2009-09-08', @c:=@c+1) as DAY
from (select @c:=-1) counter
inner join BIG_TABLE b on (1=1) limit 10;
Kaze covek:
if you have the big table which has rows count more or equal to size of necessary days sequence than you can perform the following statement (for sequence with 10 dates)
Pokusavam da shvatim kako ovo radi posto mi cak i za tabele od par stotina redova nedaje svih 10 redova koliko bi trebalo.
Moze li neko da pojasni gornji kod?
Unapred hvala,
Igor