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] [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
