Re: Copying a set of database records
| From: | Jesper Goos | Date: | Fri, 04 Mar 2005 15:57:46 +0000 |
| Subject: | Re: Copying a set of database records | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38771@lists.php.net to get a copy of this message | ||
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--