title: Wordpress: Increment time value by second(s) with MySQL query (duplicate post date + timestamp)
body: <p>I need your help.
  I'm trying to increment the post time for all posts by 1 seconds (or few seconds) in the MySQL database to get unique timestamp for every post.</p>
  <p>I have the following query:</p>
  <pre><code>set  @rownum =0;
  UPDATE wp_posts SET post_date=DATE_ADD(post_date, INTERVAL+(@rownum := @rownum +1) SECOND);
  </code></pre>
  <p>It almost works but the time will be incremented by 5 days. I don't get why so.</p>
  <p>I would be very grateful for any tips.</p>