title: Update date and time sequence with interval 1 minute MYSQL
body: <p>Example I have table like this:</p>
  
  <pre><code>id      Day             time
  1       mon       2014-01-09 11:23:00
  2       tue       2014-01-07 14:40:00
  3       wed       2014-01-08 09:23:00 
  4       thu       2014-01-09 12:23:00 
  </code></pre>
  
  <p>and I want to change the time column with sequence dan interval 1 minute
  and it would be like this:</p>
  
  <pre><code>id      Day             time
  1       mon       2014-01-16 08:01:00
  2       tue       2014-01-16 08:02:00
  3       wed       2014-01-16 08:03:00 
  4       thu       2014-01-16 08:04:00 
  </code></pre>
  
  <p>I try to update like this but doesn't work</p>
  
  <pre><code>update schemanot set timenot = ('2014-01-16 08:01:00' + interval 1 minute) where id;
  </code></pre>
  
  <p>can you help me what the syntax?</p>