How to insert possible dates between an given date range in mySql

Asked Jan 23 '14 at 04:32

Active Jan 23 '14 at 05:22

Viewed 508 times

I have a table name Event having two column Start date and End date

Event

Start_Date :2014-01-10
End_Date :2014-01-12

And another table Possible_Dates having a column Date_Val , i need to create a query which will insert all possible dates between Event table's in this table's Start_Date and End_Date in Possible_Dates

Possible_Dates

Date_Val

2014-01-10
2014-01-11
2014-01-12

edited Jan 23 '14 at 04:56

asked Jan 23 '14 at 04:32

Sonam Mohite

1

Duplicate question. See http://stackoverflow.com/questions/10132024/how-to-populate-a-table-with-a-range-of-dates for answer. – kuriouscoder Jan 23 '14 at 04:52
I need to create Query not Stored Proc. – Sonam Mohite Jan 23 '14 at 05:00
There is an answer with select and insert as well. – kuriouscoder Jan 23 '14 at 05:02
The solution of insert is not as per my question because conditional dates are not inserting over there – Sonam Mohite Jan 23 '14 at 05:07

How to insert possible dates between an given date range in mySql

Event

Possible_Dates

0 Answers0