RE: [PHP-WIN] Re: insert syntax
| From: | HKG) | Date: | Tue, 25 Nov 2003 17:33:24 +0000 |
| Subject: | RE: [PHP-WIN] Re: insert syntax | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-22189@lists.php.net to get a copy of this message | ||
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: [PHP-WIN] 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
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