You could use sql to copy that info to a separate temporary table, then update the temp table with the new data and then another call to update the main table with the new product info from the the temp table....


From: Jesper Goos <[EMAIL PROTECTED]>
To: Steve McGill <[EMAIL PROTECTED]>
Subject: Re: [PHP-DB] Copying a set of database records
Date: Fri, 04 Mar 2005 16:57:46 +0100


It can't be done in a single SQL query as SQL can't make recursive requests.
You will have to use PL/SQL, and I don't think MySql supports that.


Steve McGill wrote:

A sort of similar question to my last one:

I have a table with about 100 records all related to one product.
I want to create a new product, based on the details from the old product.

So in PHP, I would fetch the 100 records, alter the productID, and then
insert it 100 in 100 separate SQL queries.

Is there any way I can do this in one SQL query, somehow using a combination
of insert and select?

Thanks in advance!


-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to