Re: [PHP] Copying into another table

2001-11-16 Thread Andrey Hristov
, 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

Re: [PHP] Copying into another table

2001-11-16 Thread Alexander Weber
_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] Copying into another table

2001-11-16 Thread _lallous
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