Re: [PHP] Copying into another table From: Alexander Weber (aweber <email protected>)
Date: 11/16/01

_lallous wrote:
>
> 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)

Just try this one:
INSERT INTO table2 SELECT * FROM table1 WHERE (condition) 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>