Import CSV to SQLite

by

What also is being said in the comments, SQLite sees your input as 1, 25, 62, 7. I also had a problem with , and in my case it was solved by changing “separator ,” into “.mode csv”. So you could try:

sqlite> create table foo(a, b);
sqlite> .mode csv
sqlite> .import test.csv foo

The first command creates the column names for the table. However, if you want the column names inherited from the csv file, you might just ignore the first line.

— New Versions of sqlite3 —

The latest version of sqlite3 creates the table and columns for you if you let it.

You can also skip the line “.mode csv” if you append “–csv” to the end of the import statement like so:

sqlite> .import test.csv foo --csv

More Related Contents:

  1. How do I rename a column in a SQLite database table?
  2. How do I check in SQLite whether a table exists?
  3. Accessing an SQLite Database in Swift
  4. Select random row from a sqlite table
  5. How to get Top 5 records in SqLite?
  6. Insert new column into table in sqlite?
  7. How do you enable LIMIT for DELETE in SQLite?
  8. Sqlite primary key on multiple columns
  9. SQLite Schema Information Metadata
  10. How to create custom functions in SQLite
  11. SQLite: How do I save the result of a query as a CSV file?
  12. What is the difference between SQLite integer data types like int, integer, bigint, etc.?
  13. How to generate all dates between two dates
  14. SQLITE_BUSY The database file is locked (database is locked) in wicket
  15. Does it matter what extension is used for SQLite database files?
  16. SQLite “INSERT OR REPLACE INTO” vs. “UPDATE … WHERE”
  17. How do I DROP a constraint from a sqlite (3.6.21) table?
  18. Sqlite over a network share [closed]
  19. SQLite table constraint – unique on multiple columns
  20. Is there a boolean literal in SQLite?
  21. Case sensitive and insensitive like in SQLite
  22. svn cleanup: sqlite: database disk image is malformed
  23. Will SQLite performance degrade if the database size is greater than 2 gigabytes?
  24. Truncate a SQLite table if it exists?
  25. SQLite for large data sets?
  26. SQLite database supporting Unicode data
  27. Integration Testing Entity Framework code first with in-memory database
  28. How to get the number of rows of the selected result from sqlite3?
  29. How to get the last index of a substring in SQLite?
  30. SQLITE3 VACUUM, “database or disk is full”

Leave a Comment