On Jun 9, 2013, at 5:25 PM, E.Pasma <pasm...@concepts.nl> wrote: >> Yes, unfortunately. I would love to see some form of UPDATE FROM make it >> into SQLite, but none such exists at the moment. >> -- >> Igor Tandetnik >> > Possibly INSERT OR REPLACE is useful when multiple columns need to be updated.
Sadly, not quite. The semantic of of 'replace' is effectively the equivalent of 'delete + insert'… not something one usually wants. Instead of all these various exotic syntax, I would personally prefer to see SQLite offer a proper MERGE statement, which at least is defined in SQL:2003. http://en.wikipedia.org/wiki/Merge_(SQL) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
