title: Update an existing sql table based on content from an external csv file?
body: <p>I have a table like this:</p>
  
  <p>key    name   address</p>
  
  <p>1      aaa    <em>*</em>*</p>
  
  <p>2      abc    <em>*</em>*</p>
  
  <p>3      bdc    <em>*</em>*</p>
  
  <p>4      cda    <em>*</em>*</p>
  
  <p>5      dda    <em>*</em>*
  ...........</p>
  
  <p>Now I have another flat file (tab-delimited csv file) like this:</p>
  
  <p>name     phone</p>
  
  <p>abc      <em>*</em>*</p>
  
  <p>dda      <em>*</em>*</p>
  
  <p>aaa      <em>*</em>*</p>
  
  <p>This flat file will only have part of the entries in the original table. I want to update the table based on the content from the flat file (basically doing a join). Currently I am thinking to wirte some php script to do that. Basically load that flat file as array and have php code do the actual search and update. </p>
  
  <p>Is there any easier/better way to do this task? Someone suggested a tool named phpmyadmin but that doesn't seem to be able to handle this level of complex task.</p>
  
  <p>thanks.</p>