title: mysql insert update LOAD DATA LOCAL INFILE
body: <p>i am using LOAD DATA LOCAL INFILE to load data into temp table mid.then i  use a update query to update found in table product.The only matching field in both is the model.</p>
  
  <pre><code>$q  = "LOAD DATA LOCAL INFILE 'Mid.csv' INTO TABLE mid 
      FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'  IGNORE 1 LINES 
      (@col1,@col2,@col3,@col4,@col5,@col6) set model=@col1,price=@col3,stock=@col6 ";
  mysql_query($q, $db);
  
  
  mysql_query('UPDATE mid m, products p set p.products_price= m.price,p.products_quantity= m.stock where p.products_model= m.model');
  </code></pre>
  
  <p>It works and update the product table.the issue i am having is that there new records in mid table which don't get inserted as i am using the update statement.</p>
  
  <p>I have looked at the insert query and update on duplicate.I have seen loads of examples of when it has to work on one table but none where i have to match it against another table.</p>
  
  <p>Either i am searching for the wrong thing or there is another way to to do this.</p>
  
  <p>i would appreciate any help.</p>
  
  <p>regards</p>
  
  <p>naf</p>