I have a CSV file contains records with a unique randomized ID as the primary key. I retrieve a copy of the file daily and I don't have control over when old records are removed from the file. I would like to simply import this data into a table each day, ignoring the rows where I've already imported them (i.e. the primary key already exists in the database); however, if I attempt an import on a CSV file that contains a row in which the key already exists in the table, I get an error about uniqueness and none of the rows are imported. Is there a way to change this behavior, simply ignoring the pieces that fail and continuing on?
Thanks, Paul _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users