title: Update date + one year in mysql
body: <p>When I want setting numerical value +1 in mysql table, I use e.g.:</p>
  
  <pre><code>UPDATE table SET number=number+1 WHEN ...
  </code></pre>
  
  <p>How can I set date + one year?</p>
  
  <p>Thanks</p>