4 ms·
If I understand, the difference is that this allows insertion of only some columns, including the primary key. If there is an existing row, the union of all col
by anorwell 8y ago
If I understand, the difference is that this allows insertion of only some columns, including the primary key. If there is an existing row, the union of all columns will be the result. On the other hand, `INSERT OR REPLACE` completely replaces the existing row, if one exists.
- cyberferret 8y agoThanks for the quick and informative explanation. I'll admit that I didn't have time to read the entire article right now, but I will go back and look at it in more detail.