title: MySql - Deleting a row
body: <p>I've a table in MySql which includes user_id as First field. This field is a primary key and it is defined as Auto Incrementing. The problem is whenever I delete a row from the table by using the command,</p>
  
  <pre><code>delete from user where username="username"; //Username is the Second field
  </code></pre>
  
  <p>It gets deleted, but When I created a new Entry, the user_id is not adjusted by overwriting the deleted row.
  Suppose I deleted the 3rd row in table which is the last row, then my new entry is created as user_id = 4 even the user_id = 3 doesn't exist now.</p>
  
  <p>Is this how the Sqlworks works or should I have make changes in my query?</p>