After executing the following command
LOAD DATA LOCAL INFILE '/path/to/file.csv'
INTO TABLE mydb.tablename FIELDS TERMINATED BY ',';
mysql workbench's output console printed the following:
14935 row(s) affected Records: 14981 Deleted: 0 Skipped: 46
Warnings: 0
The question is, how on earth do I find out which rows were skipped?