Create a temporary table with dates

Question

How to create a temporary table and populate it with ceratin dates. I know the starting and the "limit"

• startdate = 2014-11-11
• limit = 3

Table

should look like

2014-11-11 2014-11-12 2014-11-13 

I like to use this create table to join it with another

Answer 1

You can generate dynamic dates and then paste them int into the table, as shown below. I used a table instead of a temporary table, which you can change to a temporary table.

 CREATE TEMPORARY TABLE IF NOT EXISTS dates_test (dates datetime); insert into dates_test (dates) select t1.date from ( select a.Date as date from ( select curdate() - INTERVAL (aa + (10 * ba) + (100 * ca)) DAY as Date from (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as a cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as b cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as c ) a where a.Date BETWEEN '2014-11-11' and DATE_ADD('2014-11-11' ,INTERVAL 3 DAY) )t1 

Here is the demon