title: How to update autoincremented id when delete row in table?
body: <p>I am creating application that uses MYSQL database in C#. I want to delete row and update autoincremented value of id in table. For example, I have table with two columns: id and station, and table is station list. Something like this</p>
  
  <blockquote>
    <p>id station<br>
    1  pt1<br>
    2  pt2<br>
    3  pt3  </p>
  </blockquote>
  
  <p>If i delete second row, after deleting the table looks something like this:</p>
  
  <blockquote>
    <p>id station<br>
    1  pt1<br>
    3  pt3   </p>
  </blockquote>
  
  <p>Is there any way that I update id of table, for this example that id in third row instead value 3 have value 2? 
  Thanks in advance!</p>