title: How insert data manually in sqlite in android
body: <p>I'm trying to  retrieve data from sqlite and put it into a spinner[like having provinces and cities so i want a selected province to populate its Cities] so i manage to do DBAdapter..</p>
  
  <p>1) I want to put province and cities into a database, i tried but my last option is to put it manually..so can anyone help me..HOW TO INSERT DATA MANUAL INTO DATABASE and I dont have a database yet.</p>
  
  <p>So here what I have tried since in the morning...</p>
  
  <pre><code>     db.execSQL("CREATE TABLE " + ProvinceTable + " ("+ COLUMN_PID + " INTEGER PRIMARY KEY  AUTOINCREMENT , " + COLUMN_PName + "TEXT)" );
  
       db.execSQL("CREATE TABLE " + Cities_TABLE + " ("+COLUMN_CID + " INTEGER PRIMARY KEY AUTOINCREMENT , " +COLUMN_CityNames+" TEXT," +
              ""+ COLUMN_Lat +" INTEGER, "+COLUMN_Long + " INTEGER , " + COLUMN_PID + " INTEGER NOT NULL , FOREIGN KEY ("+ COLUMN_PID +") REFERENCES " + ProvinceTable + "("+COLUMN_PID + "));");
  </code></pre>
  
  <p>I've tried using <a href="https://stackoverflow.com/questions/5307769/how-to-insert-data-manual-in-sqlite-database">this</a> solution but i'm lost I dont understand the steps</p>