Re: Copying into another table
| From: | Andrey Hristov | Date: | Fri, 16 Nov 2001 11:34:24 +0000 |
| Subject: | Re: Copying into another table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-74851@lists.php.net to get a copy of this message | ||
INSERT INTO table2 SELECT * FROM table1 WHERE (condition);
Easy, isn't it *grin*
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
----- Original Message -----
From: "_lallous" <elias_bachaalany@yahoo.com>
To: <php-general@lists.php.net>
Sent: Friday, November 16, 2001 1:16 PM
Subject: [PHP] Copying into another table
> Hello!
>
> Is there is anyway to copy from a table to another but by applying a filter?
>
> Example:
>
> SELECT * FROM table1 WHERE (condition)
> INSERT INTO table2 (the results of the last query)
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>