You are not logged in.
Announcement
Unanswered posts
|
Pages: 1

Hi everyone,
from mysql docs http://dev.mysql.com/doc/refman/5.0/en/load-data.html :
"LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE | IGNORE]
<...>
If you specify IGNORE, input rows that duplicate an existing row on a unique key value are skipped" - that is exactly what i need,
but the tmysqlbulkexec component seems to only offer the insert/replace/update options for advanced setting
"Action of data". Insert is without either of REPLACE|IGNORE, replace is with REPLACE, update creates temporary table and UPDATES
all the rows from the source table with the rows of temporary table having same keys. But i'd like to have the IGNORE statement.
is that possible?
if not, should i fill in an issue in a bugtracker?
thanks,
jamesm
Offline
Hello
Yes, you are right. You can report a new feature on our bugtracker.
Thanks for you support!
Best regards
shong
Offline
Pages: 1