title: MYSQL: Display Skipped records after LOAD DATA INFILE?
body: <p>In MySQL I've used <code>LOAD DATA LOCAL INFILE</code> which works fine. At the end I get a message like:</p>
  
  <pre><code>Records: 460377  Deleted: 0  Skipped: 145280  Warnings: 0
  </code></pre>
  
  <p>How can I view the line number of the records that were skipped? <code>SHOW warnings</code> doesn't work:</p>
  
  <pre><code>mysql&gt; show warnings;
  Empty set (0.00 sec)
  </code></pre>