php-windows | 2003112
Date: 11/25/03
- Next message: Nik: "Re: [PHP-WIN] Online Polls"
- Previous message: Herhuth, Ron: "[PHP-WIN] Encryption Decryption Help Needed"
- Maybe in reply to: Andrei BEJENARU: "[PHP-WIN] Re: insert syntax"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 <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" <rinku <email protected>> wrote in message
news:3FC390F0.4643.1634C70 <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
- Next message: Nik: "Re: [PHP-WIN] Online Polls"
- Previous message: Herhuth, Ron: "[PHP-WIN] Encryption Decryption Help Needed"
- Maybe in reply to: Andrei BEJENARU: "[PHP-WIN] Re: insert syntax"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

