topic Re: Insert or update on duplicate key or unique index in Talend Studio

Insert or update on duplicate key or unique index

_AnonymousUser — Sat, 16 Nov 2024 13:56:54 GMT

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

Re: Insert or update on duplicate key or unique index

Anonymous — Tue, 19 May 2009 23:40:39 GMT

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

Re: Insert or update on duplicate key or unique index

Anonymous — Wed, 20 May 2009 02:39:55 GMT

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