mercredi 25 février 2015

Insert external table in SQLite Android

I am creating my database SQLite in my code, on my SQLiteOpenHelper using onCreate, onUpdate, etc... I will create a lot of tables.


But i have one external table with my cities and states already filled, and I need to import it on my database. It's a big table, and I have the SQL statments to Create and Insert each row. But I don't know how I can put this on my database automatically.


I thought I would transfer my database to my computer, and use "DB Browser for SQLite" to insert the SQL code, and so I send my database to my tablet. Is there any other way? Because if I do this, everytime that I will change my database, I will do this.


Aucun commentaire:

Enregistrer un commentaire