Six Stars

tmysql output action on data

Hi Team

 

In tmysqloutput  in Action on data tab i could find Insert or update on duplicate key or unique index 

I understood the function is similar to insert or update operation but what is exact purpose of having it i have gone though help but still i ave some conflicts can you please make my understanding better on it.

 

Thanks

Saranya.

1 REPLY
Eight Stars

Re: tmysql output action on data

Hello,

How I understand it:
- If the record with the key or unique index does not exist in the table the row is inserted.
- If the record with the key or unique index does exist in the table the row with the key or index is updated.

Regards
Ondrej