Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Insert or update on duplicate key or unique index

Hi Sirs...
What exactly means "Insert or update on duplicate key or unique index"?
Thanks!
Labels (2)
2 Replies
Anonymous
Not applicable

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

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