Import a CSV File to Database
# Create a database
sqlite3 mydb.db
# Specify the CSV mode and define a table
.mode csv mytable
# Import a CSV file to mytable
.import somedata.csv mytable
# Confirm the created table
.tables
.schema mytable
# Test running a select query on the table
select * from mytable limit 10