title: Import CSV to Update rows in table
body: <p>There are approximately 26K products (posts) and each product has meta values like this:</p>
  
  <p><img src="https://i.stack.imgur.com/BUxl1.png" alt="enter image description here"></p>
  
  <p>The post_id column is the product id in db and the _sku (meta_key) is the unique id for each product.</p>
  
  <p>I've received a new CSV file that updates all of the values (meta_value) for _sale_price (meta_key) of each product. The CSV file looks like:<br>
  SKU, Sale Price</p>
  
  <p>How do I import this CSV to update only the _sale_price row based on the post_id (product id) &amp; _sku value?</p>
  
  <p>Output Example:</p>
  
  <p><img src="https://i.stack.imgur.com/rnnlF.png" alt="enter image description here"></p>
  
  <p>I know how to do this in PHP by looping through the CSV and selecting &amp; executing an update for each single product but this seems inefficient. </p>
  
  <p>Preferably with phpMyAdmin and by using LOAD DATA INFILE. </p>