When I .import a file into a table, || results in a value of '' for the
data item.
How can I get a NULL value stored?
This also happens when the item is at the end (EOL) of the row.
Currently, I:
UPDATE table SET value=NULL where value='';

Ted

---
________________________________________________________________
3.14159265358979323846264338327950  Let the spirit of pi spread
2884197169399375105820974944592307  all around the world!
8164062862089986280348253421170679  http://pi314.at PI VOBISCUM!
================================================================
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to