🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

How to INSERT IGNORE with Write Database operator....?

User: "tmyers"
New Altair Community Member
Updated by Jocelyn

Hi all. I'm using a Write Database operator to append rows to a MySQL table. I have a unique index consisting of 2 columns in the destination table. When my exampleset contains a row with a pair of values that already exists in the table, the Write Database errors and halts. I would like the operator to ignore such errors and continue to append all the rows where the pair of these values DON'T already exist in the table (i.e. to behave like a INSERT IGNORE statement). 

 

How can I run this operator so it would ignore such errors and only append "new" pairs of values?

 

Thanks in advance for any suggestions,

 

Tim

 

Find more posts tagged with