That actually doesn't work in SQLite as it checks the primary key uniqueness after every row change, not after all updates have been completed.
sqlite> update fruit set id = id + 1 where id >= 2; --EQP-- 0,0,0,SEARCH TABLE fruit USING INTEGER PRIMARY KEY (rowid>?) Run Time: real 0.000 user 0.000000 sys 0.000000 Error: UNIQUE constraint failed: fruit.id -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Monday, November 20, 2017 9:39 AM To: SQLite mailing list Subject: Re: [sqlite] how into insert row into middle of table with integer primary key UPDATE fruit SET id = id+1 WHERE id >=2; INSERT … _______________________________________________ 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