title: Deleting row from android SQLite database corrupts entries after deleted row
body: <p>Hi everyone I am fairly new to android development and have been trying to learn how to use SQL with android. I have been working with the example code from here <a href="http://www.tutorialspoint.com/android/android_sqlite_database.htm" rel="nofollow">http://www.tutorialspoint.com/android/android_sqlite_database.htm</a></p>
  
  <p>I have been able to get everything working like I want it except for the delete row function. When I delete a row the data in the rows below it become corrupt and/or out  of sync with the id column. I have been looking at examples and goggling it for the last two days but just can not find a answer so I hope one of you can help. Below is a simple example of what is happening. Let me know if I need to post any more info, any help is greatly appreciated.<a href="http://i.stack.imgur.com/kfsRh.png" rel="nofollow">Diagram of problem</a></p>
  
  <pre><code>public Integer deleteContact (Integer id)
  {
     SQLiteDatabase db = this.getWritableDatabase();
    return db.delete("contacts",
             "id = ? ",
            new String[] { Integer.toString(id) });
  
  
  }
  </code></pre>