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
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
: php-db@lists.php.net
Subject: Re: [PHP-DB] Copying a set of database records
Date: Fri, 04 Mar 2005 16:57:46 +0100
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
Jesper Goos wrote:
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.
[snip]
bubble burst=true mysql_version_required=4.1
http://dev.mysql.com/doc/mysql/en/subqueries.html
/bubble
Steve McGill wrote: