On Sat, Jun 6, 2009 at 1:43 PM, Kelly Jones<kelly.terry.jo...@gmail.com> wrote: > I have a text file onenum.txt with just "1234\n" in it, and a db w/ > this schema: > > sqlite> .schema > CREATE TABLE test (foo INTEGER PRIMARY KEY); > > When I import, it fails as follows: > > sqlite> .import onenum.txt test > Error: datatype mismatch > > Is sqlite3 treating "1234" as a string or something? Short of doing > "INSERT INTO test VALUES (1234);", how do I import numbers into > sqlite3's rowid column? [1]
Remove the "\n" > > [1] Since foo is INTEGER PRIMARY KEY, it's just an alias for rowid. > > -- > We're just a Bunch Of Regular Guys, a collective group that's trying > to understand and assimilate technology. We feel that resistance to > new ideas and technology is unwise and ultimately futile. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > - _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users