title: execSQL not working with insert
body: <p>i know that documentation says that it's better in this case to use insert instead of execSQL, but i have a very big sql-file that consist of 6000 records and it's easier for me to use execSQL, but it's not working</p>
  
  <pre><code>public class CitiesHandler extends SQLiteOpenHelper {
  
      // All Static variables
      // Database Version
      private static final int DATABASE_VERSION = 1;
  
      // Database Name
      private static final String DATABASE_NAME = "cities";
  
      // Login table name
      private static final String TABLE_REGION= "region";
      private static final String TABLE_CITY= "city";
      // Login Table Columns names
      private static final String KEY_ID = "id";
      private static final String KEY_NAME = "name";
      private static final String KEY_REGION_ID = "region_id";
      private static final String KEY_PHONE = "phone_code";
  
      public CitiesHandler(Context context) {
          super(context, DATABASE_NAME, null, DATABASE_VERSION);
      }
  
      // Creating Tables
      @Override
      public void onCreate(SQLiteDatabase db) {
          String strRegion="CREATE TABLE region (id INTEGER PRIMARY KEY,name TEXT)";
          db.execSQL(strRegion);
          String insertRegion="INSERT INTO region Values   (1, 'АР Крым') , (2, 'Винницкая область') , (3, 'Волынская область') , (4, 'Днепропетровская область') , (5, 'Донецкая область') , (6, 'Житомирская область') , (7, 'Закарпатская область') , (8, 'Запорожская область') , (9, 'Ивано-Франковская область') , (10, 'Киевская область') , (11, 'Кировоградская область') , (12, 'Луганская область') , (13, 'Львовская область') , (14, 'Николаевская область') , (15, 'Одесская область') , (16, 'Полтавская область') , (17, 'Ровенская область') , (18, 'Сумская область') , (19, 'Тернопольская область') , (20, 'Харьковская область') , (21, 'Херсонская область') , (22, 'Хмельницкая область') , (23, 'Черкасская область') , (24, 'Черниговская область') , (25, 'Черновицкая область')";
          db.execSQL(insertRegion);
      }
  
      // Upgrading database
      @Override
      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
          // Drop older table if existed
          db.execSQL("DROP TABLE IF EXISTS " + TABLE_CITY);
          db.execSQL("DROP TABLE IF EXISTS " + TABLE_REGION);
          // Create tables again
          onCreate(db);
      }
  
      public String[] getRegions(){
          HashMap&lt;String,String&gt; user = new HashMap&lt;String,String&gt;();
          String selectQuery = "SELECT  * FROM " + TABLE_REGION;
  
          SQLiteDatabase db = this.getReadableDatabase();
          Cursor cursor = db.rawQuery(selectQuery, null);
          // Move to first row
          cursor.moveToFirst();
          if(cursor.getCount() &gt; 0){
              user.put("name", cursor.getString(1));
          }
          cursor.close();
          db.close();
          String [] regions;
          regions=new String[user.values().size()];
          for (Entry&lt;String, String&gt; entry : user.entrySet()) {
              int i=0;
              regions[i] = entry.getValue();      
              i++;
          }
          // return user
          return regions;
      }
  
      public int getRegionID(String name){
          HashMap&lt;String,String&gt; user = new HashMap&lt;String,String&gt;();
          String selectQuery = "SELECT  * FROM " + TABLE_REGION+" WHERE name="+name;
  
          SQLiteDatabase db = this.getReadableDatabase();
          Cursor cursor = db.rawQuery(selectQuery, null);
          // Move to first row
          cursor.moveToFirst();
          if(cursor.getCount() &gt; 0){
              user.put("id", cursor.getString(0));
          }
          cursor.close();
          db.close();
          // return user
          return Integer.valueOf(user.get("id"));
      }
  
      public String[] getCities(int region_id){
          HashMap&lt;String,String&gt; user = new HashMap&lt;String,String&gt;();
          String selectQuery = "SELECT  * FROM " + TABLE_CITY+" WHERE region_id="+String.valueOf(region_id);
  
          SQLiteDatabase db = this.getReadableDatabase();
          Cursor cursor = db.rawQuery(selectQuery, null);
          // Move to first row
          cursor.moveToFirst();
          if(cursor.getCount() &gt; 0){
              user.put("name", cursor.getString(1));
          }
          cursor.close();
          db.close();
          String [] cities;
          cities=new String[user.values().size()];
          for (Entry&lt;String, String&gt; entry : user.entrySet()) {
              int i=0;
              cities[i] = entry.getValue();       
              i++;
          }
          // return user
          return cities;
      }
  
  }
  </code></pre>
  
  <p>thanks for any help</p>
  
  <p>it's not working - it means everytime it's empty. insert statement is not fulfilled.</p>