title: how to insert a new value in between two values in mysql .?
body: <p>I have a mySql database that contains a table have which four fields Id(primary key &amp; auto increment), Node, Distance,pressure. </p>
  
  <pre><code>ID      Node    Distance    Pressure 
  001     15       320        45
  002     16       420        41
  003     17       520        45
  .
  .
  .
  .
  10000    256     1245        1542
  </code></pre>
  
  <p>The problem is that, if you want to insert a new record then the New record's ID become 10001
  but I want to insert a New Record Between two records. for ex: i need to insert a new record between 001 and 002 here is the problem. I need the New record's ID as 002.
  currently I am solving this problem by updating tables .But it is not feasible for large number of records.</p>