This currently produces sql like this:
INSERT LOW_PRIORITY IGNORE INTO
t(a,b) values('1',''),('3','4'),(...
It would be useful to have an option in that dialog to produce separate sqls for each record, like:
INSERT LOW_PRIORITY IGNORE INTO
t(a,b) values('1','');
INSERT LOW_PRIORITY IGNORE INTO
t(a,b) values('3','4');
Reason: if I have a trigger on target table, that fills key column and trigger throws in null it inserts nothing and I don't have any idea on which record failed.
With separate insert sqls it would be clear where it failed.
Have to import csv to separate file, do joins, .... to see where the problem is.
BTW - can you make automatical BOM clearace from csv file, before making sql. BOM someties produces all kind of strange effects.