title: Adjust MySQL ID column +1
body: <p>I have about 1000 rows, and want to increment all of the rows' ID number by 1. I was thinking something like this might work</p>
  
  <p><code>UPDATE table</code></p>
  
  <p><code>SET id = id+1</code></p>
  
  <p>I tried in phpMyAdmin, but got this: Duplicate entry '2' for key 'PRIMARY'</p>
  
  <p>This makes perfect sense, but how can I get around it?</p>