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
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
>>>
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
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
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
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
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
7 matches
Mail list logo