sqlite3-doc/cli.html#csv_import should warn
that there is no way to preserve NULL with CSV.
You can even add a proof if you want,
$ sqlite3 mydata.db<<EOF
CREATE TABLE memos(a);
INSERT INTO memos VALUES(NULL);
.mode csv
.once mmm.csv
SELECT * FROM memos;
.import mmm.csv memos
.dump
EOF
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE memos(a);
INSERT INTO memos VALUES(NULL);
INSERT INTO memos VALUES('');
COMMIT;
(Thus no way to do "If no ROWID is specified on the insert, or if the
specified ROWID has a value of NULL, then an appropriate ROWID is
created automatically" mentioned in
file:///usr/share/doc/sqlite3-doc/autoinc.html )
https://www.google.com/search?q=CSV+NULL+SQLite
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
