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]
http://dev.mysql.com/doc/mysql/en/subqueries.html
Steve McGill wrote:
I have a table with about 100 records all related to
PROTECTED]>
CC: 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.
J
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 creat