SQLite Insert or Replace Where

i have a table with 3 columns, ID, Description and Key where ID is not a primary key! What i want is to insert or update/replace a current record. Example: decryptionKeys ID Description Key 999 Birthday 24.12.1988

I tried this but it won't work:

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

---

离开thr where子句

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

链接地址: http://www.djcxy.com/p/19792.html

上一篇: SQLite的UPSERT /更新或插入

下一篇: SQLite插入或替换在哪里