title: MySQL UPDATE values with sequence 1,2,3,
body: <p>I have table with position atribute 'posit' with unknown values (in my example '0') and I want to UPDATE it to 1,2,3, ... </p>
  
  <p>BEFORE:</p>
  
  <pre><code> _______________
  | title | posit |
  |---------------|
  |  test |   0   |
  |-------|-------|
  |  test |   0   |
  |-------|-------|
  |  test |   0   |
  |-------|-------|
  |  test |   0   |
  '---------------'
  </code></pre>
  
  <p>AFTER:</p>
  
  <pre><code> _______________
  | title | posit |
  |---------------|
  |  test |   1   |
  |-------|-------|
  |  test |   2   |
  |-------|-------|
  |  test |   3   |
  |-------|-------|
  |  test |   4   |
  '---------------'
  </code></pre>
  
  <p>Something like this</p>
  
  <pre><code>UPDATE myTable 
  SET posit = last_updated_value() + 1 
  WHERE title='test';
  </code></pre>
  
  <p>Is there any way to do it by SQL command? Note that 'posit' is not auto increment. I have only PHP solution.</p>
  
  <p>Thanks 
  Henry</p>