On 6/6/09, P Kishor <punk.k...@gmail.com> wrote: > 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"
Er, by "\n", I just meant that the file ended in a newline. I didn't literally type a backslash and an 'n' into the file. Note there's only line in the entire file, so there are no duplicates or misformatted entries. -- 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
