As well as ingres, postgres, Oracle, SQLServer, etc syntax. It is rather ISO-SQL 92 syntax than a specific RDBMS syntax. Just for the record.... -----Original Message----- From: Andrei BEJENARU To: php-windows@lists.php.net Sent: 2003-11-25 15:30 Subject: Re: insert syntax 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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
