On Sat, Jun 6, 2009 at 1:43 PM, Kelly Jones<[email protected]> 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > - _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
