Ankita Kumari

Ankita Kumari

  • 1.5k
  • 82
  • 11.1k

MYSQL(DYNAMIC QUERY)

Dec 10 2021 5:01 AM

I have a table mdr with field iduser, msg_count,msg_received. I want to count the msg_count  in the month of november on daywise data.

table mdr:--

iduer   msg_count    msg_receved

1             2                2011-11-06

2             4                2011-11-08

o/p like

iduser     day1      day2           day3     day4

1               2            0                0            0

 

solve this type of query in mysql  Dynamically.


Answers (1)