0

Hi i need a mysql query for the following scenario

my table contains below column (no date column in my table)

id  name

1   xxx

2   yyy

3   zzz

parmaters- from date(13-11-2017) and to date (16-11-2017)

ouput
====

name date

xxx  13-11-2017

xxx  14-11-2017

xxx  15-11-2017

xxx  16-11-2017

yyy  13-11-2017

yyy  14-11-2017

yyy  15-11-2017

yyy  16-11-2017

zzz  13-11-2017

zzz  14-11-2017

zzz  15-11-2017

zzz  16-11-2017

please help.

Thanks in advance

Raja

Sagar Gangwal
  • 7,544
  • 3
  • 24
  • 38
user3296668
  • 75
  • 1
  • 7

0 Answers0