title: Fetch data from existing sqlite database
body: <p>I am having an existing sqlite database. I am developing an android app and I want to connect it with this existing sqlite DataBase. </p>
  
  <p><strong>Problem 1:</strong>
  I have already included the sqlite database in my project via "DDMS push database function" as per my instructor's advise. Now I want to fetch the data from database, do I need to use SQLiteOpenHelper. If yes, how to use it and what will be coded in onCreate(SQLiteDatabase db) function and onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) function as we already have the Database with us, we don't really need to create it. </p>
  
  <p><strong>Problem 2:</strong>
  What should be done to simply fetch the required data from the existing database. </p>
  
  <p>Being a newbie, I am quite confused, can someone please explain these concepts and guide me to overcome this issue. Any help would be appreciated.</p>
  
  <p>I have seen a tutorial also for this purpose as sugggested by @TronicZomB, but according to this tutorial (<a href="http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/" rel="nofollow noreferrer">http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/</a>), I must be having all the tables with primary key field as _id. </p>
  
  <p>I have 7 tables namely destinations, events, tour, tour_cat, tour_dest, android_metadata and sqlite_sequence. Out of all, only tour_dest is not fulfilling the conditions of having a primary key named as _id. How to figure out this one?</p>
  
  <p>Following is the screenshot of table which is lacking the primary key field necessary for binding id fields of database tables. 
  <img src="https://i.stack.imgur.com/Saa77.png" alt="Screenshot of table which is lacking the primary key field necessary for binding id fields of database tables."></p>