Re: Duplicate all rows in a table

> 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?
>

Several ways:
uses for physical duplication

insert into <tablename> select [<columns>] from <tablename>

or for dynamic

create view xx
as
select * from <tablename>
union all
select * from <tablename>

Regards
Nicolas Received on Sun Mar 19 2000 - 08:34:34 CST