title: Reorder a MYSQL table
body: <p>I have a MySql table with a 'Order' field but when a record gets deleted a gap appears
  how can i update my 'Order' field sequentially ?
  If possible in one query 1       1</p>
  
  <pre><code>id.........order
  1...........1
  5...........2
  4...........4
  3...........6
  5...........8
  </code></pre>
  
  <p>to </p>
  
  <pre><code>id.........order
  1...........1
  5...........2
  4...........3
  3...........4
  5...........5
  </code></pre>
  
  <p>I could do this record by record </p>
  
  <p>Getting a SELECT orderd by Order and row by row changing the Order field 
  but to be honest i don't like it. </p>
  
  <p>thanks  </p>
  
  <p>Extra info : </p>
  
  <p>I also would like to change it this way : </p>
  
  <pre><code>id.........order
  1...........1
  5...........2
  4...........3
  3...........3.5
  5...........4
  </code></pre>
  
  <p>to </p>
  
  <pre><code>id.........order
  1...........1
  5...........2
  4...........3
  3...........4
  5...........5
  </code></pre>