Erik Wright <eswri...@...> writes:
> (2) Update the old table (t1) using this expression: > UPDATE OR REPLACE t1 SET f1 = (SELECT f1 FROM t2 WHERE t2.row = t1.row) WHERE t1.row IN (SELECT row FROM t2) 1. I dont think that "WHERE t1.row IN (SELECT row FROM t2)" is necessary 2. maybe you should do a little textprocessing and build a file with the necessary statements and start with <BEGIN TRANSACTION;> 1.000.000 ;-) UPDATE OR REPLACE ...; and end with <COMMIT> [...] greetings Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users