How to import load a .sql or .csv file into SQLite?
To import from an SQL file use the following: sqlite> .read <filename> To import from a CSV file you will need to specify the file type and destination table: sqlite> .mode csv <table> sqlite> .import <filename> <table>