RE: [PHP-WIN] insert syntax

insert into <target table> [(<column name>, ...)] select <[*] | [(<column name> [as <column alias>], ...)]> from <source table> [where <condtions list>] -----Original Message----- From: Rinku Shivnani To: php-windows@lists.php.net Sent: 2003-11-25 12:57 Subject: [PHP-WIN] insert syntax Dear All, I want to insert data from one table to another one. But I don't remember the syntax properly. Can you pls help me ? Insert into tablename2 as select * from tablename1 Thank you. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php