On 13 Nov 2013, at 2:15pm, Sylvain Pointeau <sylvain.point...@gmail.com> wrote:
> Hi, > >> INSERT (OR REPLACE/IGNORE) INTO table1 SELECT * FROM table2 >> Do you have specific requirements for the UPDATE features of MERGE ? > > the issue with "insert or replace" is that it will match on primary keys, > additionally (I am not 100% sure) it deletes first the row to replace it. > we cannot update then only 1 column. It's possible you should be using UPDATE OR REPLACE then. > furthermore, the merge can delete as well, it does the join on the fields > we want (not only PK), it is really wonderful. I still don't know what function that MERGE does that you can't do in SQLite. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
