title: how generate serial number in mysql database?
body: <p>I have table like this:</p>
  
  <p>table1:</p>
  
  <p><code>sr no. | id | name</code></p>
  
  <p>id is the primary key here.
  I want <code>sr no.</code> to be cyclic.<br>
  What attributes i should give to <code>sr no.</code> field?</p>
  
  <p>For example I have 5 records with <code>sr no</code> 1,2,3,4,5 and <code>id</code> 1,2,3,4,5 and i delete 3rd record then <code>id</code> will be 1,2,4,5 and <code>sr no.</code> will be 1,2,3,4 
  <code>sr no</code> should not lost its contentiousness.  </p>