title: MySQL get dates from a range for which the records does not exist in the database table
body: <p>I've a database table as below:</p>
  
  <pre><code> Sales Table 
  id  product_id  for_date
   1          10  2019-01-03
   2          12  2019-01-05
   3          16  2019-01-10
  </code></pre>
  
  <p>I want to get dates from between a custom date range for which there are no records in the table. For eg. I want to get the dates from 2019-01-01 to 2019-01-31 on which there were no sales i.e all dates from 2019-01-01 to 2019-01-31 excluding 2019-01-03, 2019-01-05, 2019-01-10. 
  Can anyone help me regarding this. Thanks in advance.</p>