I tried using mysqlimport to load data into an existing record with a primary key. The csv also had the primary key same as the one in the record. But the insert was skipped due to duplicate primary key. Is there any way mysqlimport can be used to insert into such an existing record.
I do not want to do --replace as the data existing in the record is also necessary
Thanks in advance