Here is an example how to create a table from a csv file. Multiple csv files can be built as multiple tables in a single database by including lines of command in the script file.

1. to create a db from a csv file, run the following command from command line:

sqlite3 city_pop.db < create_city.script

where city_pop.db will be the name for the newly created SQLite database file name, and create_city.script is the script containing a sequence of sqlite commands. The content of 'create_city.script' would look as follows.

.mode csv
.import city.csv cities
.exit

If multiple tables are needed in a database (from multiple csv files), you'd include multiple lines of commands, e.g.,

.mode csv
.import city.csv cities
.import names.csv names
.import population.csv pops
.exit


2. sqltocsv is a shell script that converts a SQLite database into a list of tables in CSV form.