Hi, In MySQL it's INSERT INTO table2 SELECT * FROM table1
Regards, Andrei "Rinku Shivnani" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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
