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:
There is a way to insert null values from a file without specifying it
in?
It's impossible when you use standard sqlite3 command line utility. In
your particular case you have 2 options: either write your own
application that will recognize some kind of value as null and insert
it instead of
It's impossible when you use standard sqlite3 command line utility. In
your particular case you have 2 options: either write your own
application that will recognize some kind of value as null and insert
it instead of plain text, or you can use temporary table like this:
Another way is to use
-Mensaje original-
De: Pavel Ivanov paiva...@gmail.com
Para: General Discussion of SQLite Database sqlite-users@sqlite.org
Cc: craf pyclut...@gmail.com
Asunto: Re: [sqlite] Trouble inserting null value from txt file
Fecha: Fri, 8 Apr 2011 13:34:25 -0400
There is a way to insert null
-Mensaje original-
De: Jean-Christophe Deschamps j...@antichoc.net
Reply-to: General Discussion of SQLite Database
sqlite-users@sqlite.org
Para: General Discussion of SQLite Database sqlite-users@sqlite.org
Asunto: Re: [sqlite] Trouble inserting null value from txt file
Fecha: Fri, 08 Apr