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"
leave thr where clause
INSERT OR REPLACE INTO decryptionKeys VALUES ("999","Birthday","25.12.1988")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With