>-----Mensaje original----- >De: Pavel Ivanov <[email protected]> >Para: General Discussion of SQLite Database <[email protected]> >Cc: craf <[email protected]> >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 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 plain text, or you can use temporary table like this: >CREATE TABLE tmp (name text); >Then import data (without first column) into it, then execute the >following statement: >insert into t (name) select name from tmp; >Pavel Hi Pavel. Excellent solution!, thank you very much for her. Regards. Cristian _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
