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

tools/import csv file

User, date Message
Written by BubikolRamios
7 months ago
Category: Feature discussion
327 posts since Thu, 14 Jan 10
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.

Written by BubikolRamios
7 months ago
327 posts since Thu, 14 Jan 10
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.