Re: How to copy
From: Markus Stuhlpfarrer <mstuhlpfarrer_at_hollomey.com>
Date: Wed, 26 Sep 2001 08:34:32 GMT
Message-ID: <3BB192CF.D5EB900F_at_hollomey.com>
Date: Wed, 26 Sep 2001 08:34:32 GMT
Message-ID: <3BB192CF.D5EB900F_at_hollomey.com>
you need to specify all the columns in the subselect of the insert:
insert into table_position (position,loc) (select 'C01',loc from table_position where loc=1)
Berny wrote:
> Could anyone tell me, please, how can I duplicate (or copy) part of table
> into the same table but modifying values on 1 column.
>
> e.g. table_position
>
> position loc
> A01 1
> A02 2
> B03 1
>
> I would like to duplicate lines with loc =1 but with pos = 'C01'
>
> Many thanks in advance,
Received on Wed Sep 26 2001 - 10:34:32 CEST