tools/import csv file

BubikolRamios's profile image BubikolRamios posted 10 years ago in Feature discussion Permalink
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.

BubikolRamios's profile image BubikolRamios posted 10 years ago Permalink
Have to import csv to separate file

read that as

Have to import csv to separate table

Please login to leave a reply, or register at first.