Re: [sqlite] Trouble inserting null value from txt file

2011-04-08 Thread craf
>-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&#

Re: [sqlite] Trouble inserting null value from txt file

2011-04-08 Thread craf
>-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

Re: [sqlite] Trouble inserting null value from txt file

2011-04-08 Thread Jean-Christophe Deschamps
>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

Re: [sqlite] Trouble inserting null value from txt file

2011-04-08 Thread Pavel Ivanov
> 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

[sqlite] Trouble inserting null value from txt file

2011-04-08 Thread craf
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