From: Lee Denny
Date: April 19 2005 9:54am
Subject: Duplication of records within the same table.
List-Archive: http://lists.mysql.com/mysql/182829
Message-Id: <002001c544c5$d78daec0$0100000a@BLACK2>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit

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_id is already auto_increment.

I'm sure that an INSERT .. SELECT statement should do it, but I'm unsure of
the correct syntax.

cheers,

Lee