Justtechjobs.com Find a programming school near you






Online Campus Both


php-windows | 2003112

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

insert into <target table> [(<column name>, ...)]
select <[*] | [(<column name> [as <column alias>], ...)]>
from <source table>
[where <condtions list>]

-----Original Message-----
From: Rinku Shivnani
To: php-windows <email protected>
Sent: 2003-11-25 12:57
Subject: [PHP-WIN] insert syntax

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