title: Adding 7 days to an SQL date field after creation using a trigger?
body: <p>I'm trying to add 7 days onto a date field once a user has signed up.  I take a number of details from a user on signup including <em>date_entered</em>.  It appears in the format <em>2016-05-01</em>.  I want to add 7 days to this date automatically so the <em>next_due</em> field will be populated with <em>2016-05-08</em>.</p>
  
  <p>The table is called '<code>tasks</code>' and the two fields are '<code>date_entered</code>' and '<code>next_due</code>'.</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>Question was marked as a duplicate, but where in the other question does it refer to triggers? I need some advice on creating the trigger so the date updates automatically when a new user is added. Cheers</p>