title: How to do update with LOAD DATA LOCAL INFILE without using temporary table
body: <p>I'm using the below query to update the fields in my table</p>
  
  <pre><code>LOAD DATA LOCAL INFILE '$_file'
  REPLACE INTO TABLE test_db.productsinfo
  FIELDS TERMINATED BY '\,'
  OPTIONALLY ENCLOSED BY '\"'  
  IGNORE 1 LINES 
  (\`products_id\`, 
   \`products_source\`, 
   \`quantity\`, 
   \`cost\
  ) 
  </code></pre>
  
  <p>But,<code>REPLACE</code> deletes the entire row and put's a new one ,which is not exactly the kind of update I require.
  Unfortunately I cant use a temporary table due to speed issues.
  Is there anyway to achieve the function of <code>ON DUPLICATE UPDATE</code> in this case ? </p>