I am trying to load a CSV file into a MySQL table with the
load data local statement. After loading it, the statement reports
Query OK, 1030 rows affected, 7314 warnings (0.03 sec) Records: 1043 Deleted: 0 Skipped: 13 Warnings: 7314
Fur my purposes, skipping 13 records is not OK - I'd rather have the statement to fail with an error message.
load data local statement is found in an
.sql file that I execute from a batch file, I'd also appreciate if there was a possibility to abort the execution of the batch file on the first error.
Is this somehow possible?