Re: How to copy
From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 26 Sep 2001 09:54:39 +0200
Message-ID: <9os1k0$fas$1_at_s1.read.news.oleane.net>
Date: Wed, 26 Sep 2001 09:54:39 +0200
Message-ID: <9os1k0$fas$1_at_s1.read.news.oleane.net>
"Berny" <przybe_at_yahoo.com> a écrit dans le message news: 9oqaen$g5r$1_at_news.magnet.ch...
> 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,
>
insert into table_position (position, loc) select 'C01', loc from table_position where loc=1 /
-- Have a nice day MichelReceived on Wed Sep 26 2001 - 09:54:39 CEST