>-----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 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
