Justtechjobs.com Find a programming school near you






Online Campus Both


php-windows | 2003112

RE: [PHP-WIN] Re: insert syntax From: Svensson, B.A.T. (HKG) (B.A.T.Svensson <email protected>)
Date: 11/25/03

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