How to import load a .sql or .csv file into SQLite?

by

To import from an SQL file use the following:

sqlite> .read <filename>

To import from a CSV file you will need to specify the file type and destination table:

sqlite> .mode csv <table>
sqlite> .import <filename> <table>

More Related Contents:

  1. Populate Android Database From CSV file?
  2. Version of SQLite used in Android?
  3. What are the performance characteristics of sqlite with very large database files? [closed]
  4. Copying data from one SQLite database to another
  5. How can I merge many SQLite databases?
  6. How to use mongoimport to import csv
  7. How to retrieve the last autoincremented ID from a SQLite table?
  8. How to recover a corrupt SQLite3 database?
  9. Import .csv file to Sqlite in Android
  10. SQLite UPSERT / UPDATE OR INSERT
  11. How to backup sqlite database?
  12. SQLite insert speed slows as number of records increases due to an index
  13. Convert SQLITE SQL dump file to POSTGRESQL
  14. Limit an sqlite Table’s Maximum Number of Rows
  15. Sqlite in flutter, how database assets work
  16. Android: Where are database files stored?
  17. Can I download an SQLite db on /sdcard and access it from my Android app?
  18. Populating Spinner From SQLite Database Android
  19. How to find SQLITE database file version
  20. How can I import a .sql file into my Heroku postgres database?
  21. Maximum number of rows in a sqlite table
  22. Predict next auto-inserted row id (SQLite)
  23. Android Pre-Populated Database [duplicate]
  24. How to handle authentication/authorization with users in a database?
  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. What are the main differences between Redis Pub/Sub and Redis Stream?
  28. Does anyone know of a good library for mapping a person’s name to his or her gender? [closed]
  29. Minimum GRANTs needed by mysqldump for dumping a full schema? (TRIGGERs are missing!!)
  30. Is writing server log files to a database a good idea?

Leave a Comment