wanted to get all dates in mysql result
Posted
by PankajK
on Stack Overflow
See other posts from Stack Overflow
or by PankajK
Published on 2010-04-16T07:15:15Z
Indexed on
2010/04/16
7:23 UTC
Read the original article
Hit count: 150
I have mysql table called user(id, name, join_on) join on is a date field what I want is to show in each day how many uses has been created I can use group by but it will only give me the dates when users get added like if date
4/12/10 5 users added
4/13/10 2 users added
4/15/10 7 users added
here date 4/14/10 is missing and I want listing of all dates in one month. I have one solution for it by creating another table only for adding date and that table will left join my users table on join_on and will give total result but I don't want to do that as for creating that I need to create and add entries in date table please suggest the different approach for doing so.
Thank you.
© Stack Overflow or respective owner