title: MySQL - Default Timestamp of n days in the future
body: <p>Is there anyway to set a fields default timestamp to n days in the future. For example I can setup a table as follows:</p>
  
  <pre><code>CREATE TABLE t1 (
       name varchar(64),
       ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  );
  </code></pre>
  
  <p>I would want that whenever ts is not indicated that it would set the default value for n days in the future. I've seen here that it can be done via triggers (<a href="https://stackoverflow.com/questions/4614332/inserting-default-value-as-current-date-30-days-in-mysql">Inserting default value as current date + 30 days in MySQL</a>), but is there any other way of doing this without triggers? </p>