The name of the city table. in the table there is a column Street. I have about 5 thousand street names, how can I add streets to the database? the values.put(DatabaseHelper.CİTY_STREET_COLUMN, "Улица гаршкофа н1"); method values.put(DatabaseHelper.CİTY_STREET_COLUMN, "Улица гаршкофа н1"); it adds one by one, and I have many streets, is there any way faster than writing about 5 thousand lines.

I inherit from the class extends SQLiteOpenHelper

  • one
    And what's the problem to read this list of streets programmatically (from a file, or where do you have them from) and insert it into a table? - Sergi
  • Not problems as in fact there is simply that I have a lot of files interested in the method of adding to the columns dynamically, and not one by one - elik
  • one
    I, unfortunately, have never worked with SQLite itself, but Google shows that there is a possibility of bulk insert: stackoverflow.com/questions/1609637/… - Sergi
  • Thank you read what they say - elik

0