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. furthermore, the merge can delete as well, it does the join on the fields we want (not only PK), it is really wonderful. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
