Re: [sqlite] SQLite equivalent to Oracle's MERGE INTO

' as key FROM DUAL) SRC ON (TGT.key = SRC.key) WHEN MATCHED THEN UPDATE SET TGT.NAME = NAME WHEN NOT MATCHED THEN INSERT (TGT.NAME) VALUES (SRC.NAME) It would be great to know if SQLite has support for this. Otherwise would are my options? Thanks. 2013/2/26 anydacdev anydacdev <any

[sqlite] SQLite equivalent to Oracle's MERGE INTO

I was wondering what is SQLite's equivalent to: MERGE INTO x TGT USING (SELECT NAME, KEY FROM y) SRC ON (TGT.key = SRC.key) WHEN MATCHED THEN UPDATE SET TGT.NAME = NAME WHEN NOT MATCHED THEN INSERT (TGT.NAME) VALUES (SRC.NAME) Thanks. ___