-users@sqlite.org
Subject: [sqlite] INSERT OR REPLACE without new rowid
Hello all,
I'd like to perform an update to a row if it exists (uniquely identified
by
3 text columns), otherwise insert a new row with the right data. INSERT
OR
REPLACE looks good, but it generates a new primary key each
To: sqlite-users@sqlite.org
Subject: [sqlite] INSERT OR REPLACE without new rowid
Hello all,
I'd like to perform an update to a row if it exists (uniquely identified
by
3 text columns), otherwise insert a new row with the right data. INSERT
OR
REPLACE looks good, but it generates a new primary key
Hello all,
I'd like to perform an update to a row if it exists (uniquely identified by
3 text columns), otherwise insert a new row with the right data. INSERT OR
REPLACE looks good, but it generates a new primary key each time there is a
conflict. If the row exists, I need to keep the