On 12 Jul 2016, at 1:39pm, Dominique Devienne <ddevie...@gmail.com> wrote:
> So the plural in "deletes pre-existing rows" explain that in my second > example, > with both the PK and NK where each point to different rows, both rows are > first > deleted, then the new row is inserted? Correct. There is a common assumption that INSERT OR REPLACE is just a name, and that behind the scenes the SQL engine just makes some complicated changes inside the database. But in SQLite it really does do a number of DELETEs and then an INSERT. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
