>-Mensaje original-
>De: Jean-Christophe Deschamps
>Reply-to: General Discussion of SQLite Database
>
>Para: General Discussion of SQLite Database
>Asunto: Re: [sqlite] Trouble inserting null value from txt file
>Fecha: Fri, 08 Apr 2011 19:40:07 +0200
>It
>-Mensaje original-
>De: Pavel Ivanov
>Para: General Discussion of SQLite Database
>Cc: craf
>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 values from a file without speci
>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
> 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 p
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:
sqli
5 matches
Mail list logo