title: Increment Time for every 10 Row using update in MySQL
body: <p>need an mysql update query to increment time for every 10 row by 6 seconds with the first entry time starting from a specific date-time...</p>
  
  <p>lets say <code>2015-12-08 00:00:00</code> is the timestamp i want for the first 10  entries, 
  next 10 entries should get
         <code>2015-12-08 00:00:06</code> , </p>
  
  <p>then the next 10-</p>
  
  <pre><code>2015-12-08 00:00:12
  </code></pre>
  
  <p>the next 10</p>
  
  <pre><code>2015-12-08 00:00:18
  </code></pre>
  
  <p>...and so on till last entry, the time has to increment by 6 seconds and accordingly the <code>minutes</code> and <code>hours</code> as it increases till the last entry</p>
  
  <p>any idea how to make an update query for that?</p>
  
  <p>PS: i dont have a unique id or value in the table in any column, the values may repeat. I would prefer an Update statement to use as i may have to change for other tables too,rather than triggers or Store procedure. I am using MySQL v7.02 SQLyog Enterprise</p>