Re: Duplicate all rows in a table

Sorry!

Things are so easy...

create temp_table as select * from orig_table; update temp_table set PK=concat('DUP_',PK); insert into orig_table select * from temp_table; drop table temp_table;

Again, sorry for such an easy question!

Thorsten

Thorsten Kubis schrieb:
>
> Hello all!
>
> I want to duplicate all rows in a table.
> The primary key should start with
> a suffix like "dup_".
> Is there an easier way than export, find and
> replace,import?
>
> Any ideas?
>
> Thorsten
Received on Sun Mar 19 2000 - 08:34:59 CST