title: How to increment a field in MySql using “ON DUPLICATE KEY UPDATE” when each row increment each value?
body: <p>this question like <a href="https://stackoverflow.com/questions/6802239/how-to-increment-a-field-in-mysql-using-on-duplicate-key-update-when-inserting/37809224#37809224">increment a field with same value</a> 
  but I want to achieve each row increment each value</p>
  
  <p>for example:
  a is a primary key</p>
  
  <pre><code>Original data
  a   | share_count | read_count |
  1   |     2       |     3      |
  
  through
  INSERT INTO table (a, share_count,read_count)
  VALUES(1,share_count+1,read_count+2),(2,share_count+2,read_count+3) 
  ON DUPLICATE KEY UPDATE
  a=VALUES(a),share_count=VALUES(share_count),read_count=VALUES(read_count)
  
  Goal result
  a   | share_count | read_count |
  1   |     3       |     5      |
  2   |     2       |     3      |
  </code></pre>
  
  <p>I tried,but fail.Thanks for answering</p>