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 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
