Re: [PHP-DB] Copying a set of database records

2005-03-04 Thread Martin Norland
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

Re: [PHP-DB] Copying a set of database records

2005-03-04 Thread Bastien Koert
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

Re: [PHP-DB] Copying a set of database records

2005-03-04 Thread Jesper Goos
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