Hi, In MySQL it's INSERT INTO table2 SELECT * FROM table1 Regards, Andrei "Rinku Shivnani" <rinku@banas.guj.nic.in> wrote in message 3FC390F0.4643.1634C70@localhost">news:3FC390F0.4643.1634C70@localhost... > 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
