3

I need to import a .csv file into a table based on the headers of the .csv file. The header of the .csv file contains the fields of the sql table but does not have optional fields. Does sqlite3 have the ability to do this?

For example, the table has the following schema:

CREATE TABLE "Names" (
    id INTEGER PRIMARY KEY,
    first TEXT NOT NULL,
    middle TEXT,
    last TEXT NOT NULL
);

The .csv has contains:

id,first,last
1,"Jane","Doe"
2,"John","Doe"
3,"Nikola","Tesla"

Does sqlite have the ability to load a .csv file that has missing fields into a sqlite table based on the header line in the .csv?

Something along the lines of this: How to import load a .sql or .csv file into SQLite?

EarthIsHome
  • 655
  • 6
  • 18

1 Answers1

5

The sqlite3 command-line shell can create the table from the column headers.

But if the table already exists, it assumes that all lines in the file contain data (although you can skip header line since version 3.32), and that the number of columns is the same.

You have to use (or write) some different import tool.

CL.
  • 173,858
  • 17
  • 217
  • 259
  • `if the table exists, it assumes that all lines in the file contain data` – this is not 100% accurate. You can use `--skip 1` to skip a header. This is not relevant for this question, but may help those who land here from Google search. – Victor Sergienko Jan 24 '22 at 19:18