MySQL Select records for each date in month even if records does not exist for specific date : <p>I have a table with records having created_date field. I want to select records for each date in current month, even if there is not record for any specific date.</p>

<p>I want records as :</p>

<p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-html lang-html prettyprint-override"><code>created_on | name
-----------------------
2018-01-01 | ABC
2018-01-02 | XYZ
2018-01-03 | MNO
...
...
2018-01-30 | FAQ
2018-01-31 | PQR</code></pre>
</div>
</div>
</p>
