RE: [sqlite] Update Columns in One Table Using Values From Another Table

2007-08-24 Thread Tom Briggs
and then use insert or replace to get them into the table. -T > -Original Message- > From: Chris Peachment [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 23, 2007 2:15 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Update Columns in One Table Using > Values

Re: [sqlite] Update Columns in One Table Using Values From Another Table

2007-08-23 Thread Kees Nuyt
On Thu, 23 Aug 2007 14:15:00 -0400, you wrote: >On Thu, 23 Aug 2007 18:58:32 +0200, Kees Nuyt wrote: > >>Hi Chris, > >>On Thu, 23 Aug 2007 12:14:51 -0400, you wrote: > >>>On Thu, 23 Aug 2007 08:52:40 -0700, Gerry Snyder wrote: >>> Will INSERT OR REPLACE do what you want? >>> Gerry >>>

Re: [sqlite] Update Columns in One Table Using Values From Another Table

2007-08-23 Thread Chris Peachment
On Thu, 23 Aug 2007 18:58:32 +0200, Kees Nuyt wrote: >Hi Chris, >On Thu, 23 Aug 2007 12:14:51 -0400, you wrote: >>On Thu, 23 Aug 2007 08:52:40 -0700, Gerry Snyder wrote: >> >>>Chris Peachment wrote: I have a database with more than 200,000 records in the core table. An update table of

Re: [sqlite] Update Columns in One Table Using Values From Another Table

2007-08-23 Thread Gerry Snyder
Chris Peachment wrote: On Thu, 23 Aug 2007 08:52:40 -0700, Gerry Snyder wrote: Chris Peachment wrote: I have a database with more than 200,000 records in the core table. An update table of similar record count contains a proper subset of the core table columns. I'm looking for a fast

Re: [sqlite] Update Columns in One Table Using Values From Another Table

2007-08-23 Thread Kees Nuyt
Hi Chris, On Thu, 23 Aug 2007 12:14:51 -0400, you wrote: >On Thu, 23 Aug 2007 08:52:40 -0700, Gerry Snyder wrote: > >>Chris Peachment wrote: >>> I have a database with more than 200,000 records in the >>> core table. An update table of similar record count contains >>> a proper subset of the

Re: [sqlite] Update Columns in One Table Using Values From Another Table

2007-08-23 Thread Chris Peachment
On Thu, 23 Aug 2007 08:52:40 -0700, Gerry Snyder wrote: >Chris Peachment wrote: >> I have a database with more than 200,000 records in the >> core table. An update table of similar record count contains >> a proper subset of the core table columns. >> >> I'm looking for a fast method of merging

Re: [sqlite] Update Columns in One Table Using Values From Another Table

2007-08-23 Thread Gerry Snyder
Chris Peachment wrote: I have a database with more than 200,000 records in the core table. An update table of similar record count contains a proper subset of the core table columns. I'm looking for a fast method of merging the values in the two tables such that : 1. core table columns are