Insert or update on duplicate key or unique index

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!
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