--- Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> > UPDATE T1
> >SET T1.title = T2.title
> > FROM T2
> > WHERE T1.id = T2.id
> >AND T1.title IS NULL;
>
> Thanks much RIchard, but neither of those work. For me table t1 has
> over 6 million rows, and table t2 has about 600,000. In both of
Phoenix Kiula wrote:
On 16/08/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
--- Phoenix Kiula <[EMAIL PROTECTED]> wrote:
On 16/08/07, Rodrigo De León <[EMAIL PROTECTED]> wrote:
On Aug 15, 11:46 pm, [EMAIL PROTECTED] ("Phoenix Kiula") wrote:
Appreciate any tips, b
On 16/08/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
>
> --- Phoenix Kiula <[EMAIL PROTECTED]> wrote:
>
> > On 16/08/07, Rodrigo De León <[EMAIL PROTECTED]> wrote:
> > > On Aug 15, 11:46 pm, [EMAIL PROTECTED] ("Phoenix Kiula") wrote:
> > > > Appreciate any tips, because it would
> > > > be n
On 16/08/07, Rodrigo De León <[EMAIL PROTECTED]> wrote:
> On Aug 15, 11:46 pm, [EMAIL PROTECTED] ("Phoenix Kiula") wrote:
> > Appreciate any tips, because it would
> > be nasty to have to do this with millions of UPDATE statements!
>
> - Create an interim table
> - COPY the data into it
> - Do an U
On Aug 15, 11:46 pm, [EMAIL PROTECTED] ("Phoenix Kiula") wrote:
> Appreciate any tips, because it would
> be nasty to have to do this with millions of UPDATE statements!
- Create an interim table
- COPY the data into it
- Do an UPDATE ... FROM ...
---(end of broadcast)---
What is the fastest way to import the values of *only one* column into
an already existing table? Say the table looks like this:
id (primary key)
description
created_on
I want to import only a new column so the table looks like this:
id (primary key)
title
description
created_on
S
