MYSQL: Load Data Infile but update if same key found?

I have a members table. Half the data/fields are populated through an online CMS.

But for the member's core contact detail fields, they come from a CSV exported from a desktop database.

I wanted to be able to upload this CSV and use the LOAD DATA command to update the members contact detail fields (matching on id) but without touching/erasing the other fields.

Is there a way to do this or must I instead loop through each row of the CSV and UPDATE... (if that's the case, any tips for the best way to do开发者_Go百科 it?)

The Load Data Infile command supports the REPLACE keyword. This might be what you're looking for. From the manual:

REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted

The Load Data Infile command also has options where you can specify which columns to update, so perhaps you can upload the data, only specifying the columns which you want to update.