MYSQL: Display Skipped records after LOAD DATA INFILE?

Question

In MySQL I've used LOAD DATA LOCAL INFILE which works fine. At the end I get a message like:

Records: 460377  Deleted: 0  Skipped: 145280  Warnings: 0

How can I view the line number of the records that were skipped? SHOW warnings doesn't work:

mysql> show warnings;
Empty set (0.00 sec)

Answer 1

It seems that there is no straightforward built-in method to do (source). However, this site, talks about loading the data into another table and doing a query to find the rows that were skipped.