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