Get new table with all dates between 2 dates in original table

1
votes

I'm starting with a table that looks like this:

enter image description here

And I need to create a new table that has a single record for each date between the start and end dates for each id:

enter image description here

sql
Does this answer your question? mysql search events between dates? - Luuk