SQLite Insert or Replace

Question

SQLite Insert or Replace

I have a table with three columns, identifier, description and key, where the identifier is not the primary key! I want to insert or update / replace the current record. Example: decryptionKeys ID Description Key 999 Birthday 12.24.1988

I tried this, but this will not work:

INSERT OR REPLACE INTO decryptionKeys VALUES ("999","Birthday","25.12.1988") WHERE ID="999" AND Description="Birthday"

+5

sql sqlite

Manu May 13, '12 at 16:13

source share

1 answer

juergen d · Accepted Answer · 2012-05-13T16:19:22+0000

leave tr where is the offer

INSERT OR REPLACE INTO decryptionKeys VALUES ("999","Birthday","25.12.1988")

SQLite Insert or Replace

More articles: