title: Mysql table format for store last 30 days Data
body: <p>I want to add this data  : </p>
  
  <pre><code>id,prod_name,value,date
  
  1,samsung,340,02-02-2014
  2,nokia,390,02-02-2014
  3,samsung,340,03-02-2014
  4,samsung,440,04-02-2014
  </code></pre>
  
  <p>Main problem is create each  rows for each day records......So any way possible to no need  to create every day record for each product</p>
  
  <p>i want to save last 30 days data.</p>