Skip to content

Instantly share code, notes, and snippets.

@ybakos

ybakos/sqlite import csv

Created September 30, 2009 14:21
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ybakos/198130 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ybakos/198130 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqlite import csv
Enter ".help" for instructions
sqlite> CREATE TABLE data (name STRING, address STRING, salary INTEGER);
sqlite> .mode csv
sqlite> .import out.csv data
sqlite> .quit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment