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

Filed under:
|
|

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

Related posts about mysql

Related posts about sql