I need to do a query and join with all days of the year but in my db there isn't a calendar table. After google-ing I found generate_series() in PostgreSQL. Does MySQL have anything similar? My actual table has something like: date qty 1-1-11 3 1-1-11 4 4-1-11 2 6-1-11 5 But my query has to return: 1-1-11 7 2-1-11 0 3-1-11 0 4-1-11 2 and so on ..
![generate_series() equivalent in MySQL](https://cdn-ak-scissors.b.st-hatena.com/image/square/98d6f053a97a87156775f60757c60865d0f2c47d/height=288;version=1;width=512/https%3A%2F%2Fcdn.sstatic.net%2FSites%2Fstackoverflow%2FImg%2Fapple-touch-icon%402.png%3Fv%3D73d79a89bded)