title: mysql update a table with LOAD DATA
body: <p>So I have someone working on a csv (generated from my table) where they will be updating some fields by hand. This may happen multiple times. I'd like to take the modified csv and update my existing table.</p>
  
  <p>From my understanding, I will need to create a tmp table and then use that to update the existing table. So I can create the temporary table, but how can I iterate through that table and use it to update the existing table?</p>
  
  <p>My sql querying skills are pretty basic. I think its possible, but I'm not sure where to start.</p>