Re: [PHP] Copying into another table

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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 16, 2001 1:16 PM Subjec

Re: [PHP] Copying into another table

_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)