Hi
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.
Jesper
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! Steve
--
