title: android sqllite database rowid increment while insertion
body: <p>I have a table in my database with one field declared as </p>
  
  <pre><code>_id integer primary key
  </code></pre>
  
  <p>There is no AUTOINCREMENT.</p>
  
  <p>Here i have a doubt about how rowid will be updated during insert after a delete. what i observed is </p>
  
  <ol>
  <li>if the last row id is x and it is deleted, the next row inserted gets id x.</li>
  </ol>
  
  <p>But if i delete some other rows with id &lt; x and then insert a new row the rowid of the newly inserted row is x+1 .</p>
  
  <p>Please confirm is my observation right ( rowid reused only if the last rows are deleted and not in between rows. )</p>
  
  <p>I saw the explanation for AUTOINCREMENT. I want to know the behaviour when no AUTOINCREMENT is set</p>