Рет қаралды 4,939
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.