, 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 que
_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)
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: [EMAIL PROTECTED]
For additional c
3 matches
Mail list logo