On 8.01.20 01:04, Simon Slavin wrote: > On 8 Jan 2020, at 12:00am, Michael Kappert <michael.kapp...@gmx.net> wrote: > >> REPLACE INTO > > REPLACE INTO is an alias for INSERT OR REPLACE. So you should assume that > the command will do either an INSERT or a REPLACE. > > See the notes about REPLACE on this page: > > <https://sqlite.org/lang_conflict.html> > > Is the behaviour you're seeing consistent with that documentation ?
Argh, I somehow managed to skip the pointer to that page when reading this <https://sqlite.org/lang_insert.html>. So I need to provide an upsert clause to make the replace behave as an UPDATE. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
