What is an “upsert” DML statement in Salesforce?

SFDC-Interview-Questions-AnswersDML stands for Data Manipulation Language.
UPSERT is a one of the DML operation.

When a record is upserted (ex: upsert account/contact record;), the system updates the account/contact record if it already exists. Else, the account/contact record is inserted.This operation is particularly very helpful when you have a set of records of which a few have to be inserted and others updated. The upsert operation combines both insert and update into one.

Written by 

I am Sakthivel Madesh, a certified Salesforce Advanced Developer & Administrator working on Salesforce Technology since 2011. I am currently working in Techforce Services as Sr. Salesforce Developer. I have worked on multiple technologies Like PHP, Java, Salesforce, I am very passionate about Salesforce and to earn 15x Salesforce Certification. I love Trailhead for learning Salesforce Skill and Become a Trailhead 5x Ranger too. I Love to Learn & Share my Salesforce knowledge to Salesforce Learners/Beginner using My Blog and Salesforce Community.

Leave a Reply

Your email address will not be published. Required fields are marked *