IICS | Upsert (Update else Insert) example |
1. In case of duplicate records UPDATE operation given priority.
2. But the key thing the target table must have PRIMARY KEY defined to make use of this operation.
3. Hence, all records would be handled as UPDATE otherwise INSERT would be considered as fresh record.
4. Be mindful to use this logic whenever you deal with small volume of data to foresee good performance.
![Best Dubstep Mix 2021 [Brutal Dubstep Drops],Gaming Dubstep Mix](https://images.videosashka.com/watch/hskp_5uxw00)
![Everyone Bullies Ui-mama With Ui-Beams (Koyori, Lize, Furen, Haneru, Patra, Siro, Aoi) [Eng Subs]](https://images.videosashka.com/watch/2kYfGFujdVs)
