Cacher is the code snippet organizer for pro developers

drop temporary table if exists cal
;

create temporary table cal
select date_format(date_add('2018-12-31', interval seq.n day), '%Y-%m-%d') dt
from (
	select 0 n from dual where @i:=0
	union all
	select @i:=@i+1 from `information_schema`.columns limit 10
) seq