ON CONFLICT REPLACE in #sqlite deletes the conflicting row and inserts a new one. ...

serpent7776(62)
Published in
DBuzz
Words
31
Reading
1 min
2y
Listen to this post
~1 min

... This means that the primary key will be changed unless you specify it directly. Use INSERT ... ON CONFLICT DO UPDATE to keep the old id.
#sql



sqlite
sql
via dBuzz
This post was published via dBuzz. Ecency is not the originator or editor of this content and displays it for discovery purposes only.
1
ON CONFLICT REPLACE in #sqlite deletes the conflicting row and inse... | Ecency