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: [EMAIL PROTECTED] Sent: 2003-11-25 15:30 Subject: [PHP-WIN] Re: insert syntax 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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
