Copying data from one SQLite database to another

by

You’ll have to attach Database X with Database Y using the ATTACH command, then run the appropriate Insert Into commands for the tables you want to transfer.

INSERT INTO X.TABLE SELECT * FROM Y.TABLE;

Or, if the columns are not matched up in order:

INSERT INTO X.TABLE(fieldname1, fieldname2) SELECT fieldname1, fieldname2 FROM Y.TABLE;

More Related Contents:

  1. Version of SQLite used in Android?
  2. What are the performance characteristics of sqlite with very large database files? [closed]
  3. How can I merge many SQLite databases?
  4. How to retrieve the last autoincremented ID from a SQLite table?
  5. How to import load a .sql or .csv file into SQLite?
  6. How to recover a corrupt SQLite3 database?
  7. SQLite UPSERT / UPDATE OR INSERT
  8. How to backup sqlite database?
  9. SQLite insert speed slows as number of records increases due to an index
  10. Convert SQLITE SQL dump file to POSTGRESQL
  11. Limit an sqlite Table’s Maximum Number of Rows
  12. Sqlite in flutter, how database assets work
  13. Android: Where are database files stored?
  14. Can I download an SQLite db on /sdcard and access it from my Android app?
  15. Populate Android Database From CSV file?
  16. Populating Spinner From SQLite Database Android
  17. How to find SQLITE database file version
  18. Maximum number of rows in a sqlite table
  19. Predict next auto-inserted row id (SQLite)
  20. Variable table name in sqlite
  21. Android Pre-Populated Database [duplicate]
  22. Best way to work with dates in Android SQLite [closed]
  23. What is the difference between an entity relationship model and a relational model?
  24. Best practices for storing postal addresses in a database (RDBMS)?
  25. Is it possible to generate django models from the database?
  26. How to create an auto delete mechanism for firestore? (deleting data after time period) [closed]
  27. Alternatives to Entity-Attribute-Value (EAV)?
  28. What are the main differences between Redis Pub/Sub and Redis Stream?
  29. CAP theorem – Availability and Partition Tolerance
  30. SQLiteOpenHelper onUpgrade() Confusion Android

Leave a Comment