Hi.
I'm new to SQLite and I am looking for a way to insert null data from
txt file.
My database is:
CREATE TABLE t (id integer primary key autoincrement,
name text);
The data in the file data.txt are:
null,"Peter"
null,"Xavier"
The problem occurs when I import the data:
sqlite>.separator ','
sqlite>.import data.txt t
The error that throws me is:
"Error: datatype mismatch"
It is due to null, but I tried to put as:
"null","Peter"
'null','Peter'
'','Peter'
,'Peter'
But none of these options recognizes me.
There is a way to insert null values from a file without specifying it
in?
Sorry for my English!
Regards
Cristian
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
