title: How to update a MySQL table with fresh data currently in Excel?
body: <p>It was easy using phpMyAdmin to pull a list of WordPress admin comments that were missing an IP location, but now that I've got that data in hand I'm looking for a quick way to insert it into the table. My guess is that'll probably be the use (upload) of a .sql file.</p>
  
  <p>» <a href="http://codex.wordpress.org/images/9/9e/WP3.0-ERD.png" rel="nofollow">WordPress ERD</a></p>
  
  <p>I've currently got my fresh data in an Excel sheet, with columns for comment_ID and comment_author_IP. There are several hundred records, with a variety of IP addresses.</p>
  
  <p><strong>UPDATE:</strong></p>
  
  <p>The winning query:</p>
  
  <pre><code>UPDATE wp_comments x, temp xx
  SET x.comment_author_IP = xx.IP
  WHERE x.comment_ID = xx.ID;
  </code></pre>