On Sep 15, 2014, at 7:08 PM, Hick Gunter <h...@scigames.at> wrote: > Maybe you can reformulate the query to fit > > INSERT OR UPDATE INTO t SELECT t.a,t.b,...,s.x,s.y FROM t, s …
There is no such a thing as 'INSERT OR UPDATE’ in SQLite. There is a ‘REPLACE’, but it’s definitively not the same as an update. Anyway, what the OP would benefit from is a straightforward MERGE statement: http://en.wikipedia.org/wiki/Merge_(SQL) But there is no such functionality in SQLite either. Sigh... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users