sqlite> create table test (id integer, datatype_id integer, level integer, meaning text); sqlite> .separator "," sqlite> .import no_yes.csv test
http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles
Wednesday, July 11, 2012
http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles
5
Khalid's Python Journal: csv to sqlite3 via shell
sqlite> create table test (id integer, datatype_id integer, level integer, meaning text); sqlite> .separator "," sql...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment