With Text Import, how to ignore duplicate PK entries? |
Posted in 15th, 09/2007 05:05 by elpuma |
Using mysql 4.x, DB Manager 3.x and importing a CSV, how can I enable IGNORE during a text import?
Currently the text import stops when it encounters a duplicate PK entry. I want the import to continue and ignore the line being submitted.
> from mysqlimport: The REPLACE and IGNORE keywords control handling of input rows that duplicate existing rows on unique key values. If you do not specify either option, an error occurs when a duplicate key value is found, and the rest of the text file is ignored. El |
Legends
Topic has Replies
Topic With no Replies
|
|
|