Re: Duplication of records within the same table.

From: "Lee Denny" > site_id, page_id,header_text,main_text.. > > I just need to duplicate existing records with a new site_id, so : > > 1,1,Hello,some text.. > 1,2,Hello Again, some more text... > > gets copied to > > 2,3,Hello,some text.. > 2,4,Hello Again, some more text... > > page_id is already

Duplication of records within the same table.

Hello, I've got a table with a simple structure: site_id, page_id,header_text,main_text.. I just need to duplicate existing records with a new site_id, so : 1,1,Hello,some text.. 1,2,Hello Again, some more text... gets copied to 2,3,Hello,some text.. 2,4,Hello Again, some more text... page_i