On 7/13/16, William De Luca <qops1...@icloud.com> wrote:
> Hey all,
>
> I am wondering if anyone knows some parameter I can use that will allow a
> CSV import to skip unique entries instead of bailing on the whole process.
>

Import into a TEMP table with no constraints.  Then move from the TEMP
table into your real table using "INSERT OR IGNORE INTO real_table
SELECT * FROM temp_table;"
-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to