distal-attribute
distal-attribute
distal-attribute
distal-attribute

tools/import csv file

BubikolRamios posted 12 months ago in Feature discussion
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 posted 12 months ago
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.