One Star

Insert or update on duplicate key or unique index

Hi Sirs...
What exactly means "Insert or update on duplicate key or unique index"?
Thanks!
2 REPLIES
Seventeen Stars

Re: Insert or update on duplicate key or unique index

hi,
have a look on that documentation
I think it could help you
regards
laurent
Community Manager

Re: Insert or update on duplicate key or unique index

Hello guy
The difference between update or insert and insert or update is the following :
update or insert : Will first try to update, if it can't (because record doesn't exist), it will try to insert.
insert or update : Will first try to insert, if records already exists (primary key already exists), it will try to update the record.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business