SQLite import CSV data

If you want to import a CSV file into a SQLite database it's quite simple. First create a table with the same number of columns.

CREATE TABLE Foo (Col1, Col2, Col3);

Then change the default separator to a comma and run .import against the CSV.

.separator ,
.import /tmp/foo.csv Foo


Note: Replies will be formatted with PHP Markdown Extra syntax.

Name: Email (Not Required):
 
Logged IP: 18.97.9.173
To prevent spam please submit by clicking the kitten: