On 7/13/16, William De Luca <[email protected]> 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
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to