SQLITE3 CLIENT (CLI):

CUSTOMIZE THE SQLITE3 CLIENT:

$ vim ~/.sqliterc
.headers on
.mode column
.nullvalue ¤
.prompt "> "
.timer on

CREATE A SQLITE DATABASE AND ENTERING THE CLIENT:

$ sqlite3 airports.db

The steps below require you to be in the sqlite3 client prompt.

IMPORT A CSV (CONTAINING THE COLUMN HEADERS) AS A TABLE:

.mode csv
.separator ","
.import airports.csv airports

CHECK A TABLE SCHEMA:

.schema airports