On Thu, Aug 5, 2010 at 01:17, Igor Tandetnik <itandet...@mvps.org> wrote: > > Or, if t1.ID is a primary key or otherwise has a unique constraint: > > insert or replace into t1(ID, name) > select ID, name from t2;
this one is different because it would cause INSERTs into t1 if some ID exists in t2 and not t1. -- Benoit Mortgat 20, avenue Marcel Paul 69200 Vénissieux, France +33 6 17 15 41 58 +33 4 27 11 61 23 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
