On Fri, May 9, 2008 at 9:00 AM, Beverly Seavey <[EMAIL PROTECTED]> wrote: > I have tried to import data from a file in the same directory. I have > tried leaving out the primary ley > value in the file, giving the complete path of the text file, quoting > the text file, explicitly changing the separator... > I can type in a record just fine. Why can't I get .import to work? > > hornbill% 10:43>cat testD.txt > 1|11|10|10|29|1|1 > 2|10|11|11|39|2|1 > 3|10|11|11|30|3|1 > 4|11|11|11|17|4|1 > 5|11|11|11|23|5|1 > . > . > hornbill% 10:43>od -c testD.txt | more > 0000000 1 | 1 1 | 1 0 | 1 0 | 2 9 | 1 | > 0000020 1 \n 2 | 1 0 | 1 1 | 1 1 | 3 9 | > 0000040 2 | 1 \n > > > hornbill% 10:45>sqlite interactions.db > SQLite version 2.8.17 > Enter ".help" for instructions > sqlite> select * from sqlite_master; > table|HMMpair|HMMpair|9|create table HMMpair (HMMpairID INTEGER PRIMARY KEY, > > DnumStages INTEGER, > > LnumStages INTEGER, > > seed INTEGER, > > numTrees INTEGER, > > numLeaves INTEGER, > > paramSet INTEGER) > sqlite> .import testD.txt HMMpair > unknown command or invalid arguments: "import". Enter ".help" for help
I'm new to the list, so I'm probably wrong, but try sqlite3 instead of sqlite > hornbill% 10:45>sqlite3 interactions.db <--- Note the 3 I don't think 2.8 has import. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users