> On Mar 9, 2018, at 1:42 PM, Simon Slavin <slav...@bigfraud.org> wrote: >
> "replace" means "delete the original row, then insert a new one”. More properly, it means “delete any and all rows that might cause any conflict with inserting the new row.” There really isn’t a concept of an “original” row, it just happens that the most common conflict is primary key. It’s also true that inserting a single row with “insert or replace” can cause multiple rows to be deleted (if there are multiple constraints across multiple columns, for example). -j _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users