title: MySQL default date() + 14 days, for a column?
body: <p>I was wondering if the following is possible to do through MySQL or will it have to be done using PHP.</p>
  
  <p><strong>Task - "Expiry Date"</strong></p>
  
  <ol>
  <li>User enters product name</li>
  <li>User clicks submit form button</li>
  <li>Data is POST'ed and then sent to MySQL</li>
  <li>Expiry date = date now + 14 days</li>
  </ol>
  
  <p>What I am trying to achieve is a way for mysql to insert an "expiry_date" in a table column that will equal 14 days after the date the row was created in that table.</p>
  
  <p>e.g.</p>
  
  <pre><code>product_name - foo
  entry_date - 2012-02-01
  expiry_date - 2012-02-15
  </code></pre>
  
  <p>I have a feeling it may not be possible to do in mysql unless using a stored procedure.</p>
  
  <p>I am happy to do it in PHP however I was hoping if I could do it with mysql it would leave less scope for error in my system.</p>
  
  <p>Thanks</p>