Thanks igor - ill give that a go. On 6 August 2010 16:36, Igor Tandetnik <itandet...@mvps.org> wrote: > Paul Sanderson <sandersonforens...@gmail.com> wrote: >> I have two tables and I want to copy (occasionally) a few thousand >> columns that have been added to table1 into table2, both tables have >> the same unique key but otherwise the columns are different. >> >> table2 will be initially populated from table1 using >> >> INSERT into table table2 SELECT refno from table1 WHERE flag > 0 >> >> I could drop table2 and then do the above but will then obviously lose >> any data that has been modified in table2. How can I just append the >> new rows from table1 into table2 > > If refno is a primary key in table2, or has a unique constraint on it, you > can do > > insert or ignore into table2(refno) > select refno from table1; > > "or ingore" part instructs SQLite to skip over all rows that would cause > uniqueness conflict if inserted. > -- > Igor Tandetnik > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >
-- Paul Sanderson Sanderson Forensics +44 (0)1869 325667 www.sandersonforensics.com http://www.twitter.com/sandersonforens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
