>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 Pavel's suggestion to reserve some rare arbitrary string and use an insert trigger to convert the value into actual SQL null. BTW, beware that triggers can slow down insert rate seriously. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
