title: MySQL syntax for inserting a new row in middle rows?
body: <p>mysql sintax for insert a new row in middle rows or wherever we want without updating the existing row, but automatically increment the primary key (id)?</p>
  
  <pre><code>' id | value
  ' 1  | 100
  ' 2  | 200
  ' 3  | 400
  ' 4  | 500
  </code></pre>
  
  <p>I want to insert a new row after id 2, with a value = 300. I want the output as below:</p>
  
  <pre><code>' id | value
  ' 1  | 100
  ' 2  | 200
  ' 3  | 300  &lt;-- new row with id (automatic increment)
  ' 4  | 400  &lt;-- id=id+1
  ' 5  | 500  &lt;-- id=id+1 
  </code></pre>
  
  <p>Thanks.</p>